P3 Adaptive
Hello P3 Adaptive Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots.
Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
With a background in finance and a history of great communication and a passion for problem-solving, Ed Hansberry, an Assistant Director with P3 Adaptive, embodies the spirit of P3 Adaptive. Ed was recently awarded his 13th Microsoft MVP Award so of course, we wanted to know more about his achievement, his passions, his adaptability, and most of all, his insights on change so we invited him to join us today for a chat.
This is one of those things where I spent a lot of time figuring out how to do something non-obvious. And hey, that’s usually a good thing to share! Keeps others from burning needless time, pushes the envelope a bit, inspires “riffs” and improvements on the core idea, etc.
I’d like to drop some reporting knowledge. I’m going to share some of my best practices for Power BI Reporting I’ve developed over the years
By Avi Singh [Twitter] If you want to look for trends based on weekday (Sunday…Saturday) or month-of-the-year seasonality (January…December), Cycle Plots can be a potent visualization tool.
I was recently helping a forum member at https://powerpivotforum.com.au with a problem about how to dynamically calculate an employee’s age.
On today’s episode, we bring back the greatest of the great, the all-time champ of Raw Data Downloads, the DAX Demon himself, The Scree! I am sure you will recall His Un-Deadness, evil genius of the Undead Lords Guild from his record-setting, chart-topping, last appearance on our show where he shared the secrets of the inner workings of gaming guilds and data.
Trailing twelve months (TTM) Power BI. Show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance in one table.
Today, I’ll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles… and yes, I’ll throw in a Greatest Formula In the World (GFITW) version, too.