Posts filed under Intermediate

P3: Power Query (M)agic Part 3: Divide & Conquer

Article by: Reid Havens

Welcome back P3 Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting! You’re now knowledgeable enough about Power Query (if you read Part One and Part Two, anyway) that I want to throw some cool techniques at you involving M code. The time has come to take off the metaphorical training wheels, dive into the deep end, leave the nest, take a leap of faith (boy does this guy love idioms…), because frankly you are READY FOR IT“I know it, you know it, everyone knows it.”

Posted on November 9, 2017 and filed under Power Query, Intermediate, PowerPivotPro.

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.

Posted on September 28, 2017 and filed under Power BI, DAX, Intermediate, PowerPivotPro.

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…

Posted on September 1, 2017 and filed under PowerPivotPro, DAX, Intermediate, Power BI, Power BI Features.