P3: DAX Reanimator Series: Top Performers using SUMMARIZE

Article by: Reid Havens

Welcome back P3 nation, today I’d like to demonstrate some exciting ways to show Top Performing “things” using DAX. Most of what we’ll discuss has been covered before in previous posts written here at PowerPivotPro. Rob has extensively covered the topic of Top Performing “things” in not one, not two, but THREE previous posts! So today I want to start us off by reviewing these awesome techniques, and taking a look at how to some of those practices can be used in a Power BI report.

P3: DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)

Article by: Fred Kaffenberger

Report Design by: Reid Havens

In 2013, Rob showed how to use a disconnected table and slicer to show moving averages with a variable time period. That post built on an earlier post, which steps through the process of creating moving averages. What-If-Parameters, teased at…

P3: DAX Reanimator Series – Part 3: Compare Product Performance After Launch

Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about. It’s an article that does some really cool magic using DAX, business logic, and a clever model design. It showcases a problem and solution that I think a LOT of companies experience. Frankly, if you sell a product or service, good chance you want to know how successful it is after launch.

P3: DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Article by: Reid Havens

Guess how many articles are here on PowerPivotPro.com?  Go ahead and think of a number, I’ll wait. The answer, at time of writing, is 923.  Rob alone has published 715 articles!  And these date all the way back to 2009. A lot of these articles are “old,” but folks, the DAX engine is still 99% the same today in Power BI (and Excel 2016) as it was when it first “hit the shelves” in Spring 2010....