Posts filed under PowerPivotPro

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: Power BI Feature Spotlight: Report Drill Through

Article by: Reid Havens

Every month Power BI gets an update that adds a nice handful of  new features. Here at P3 we ALL get excited for this! We often stand around the water cooler talking about all the new features.When a REALLY exciting feature comes out we get as gleeful as school children! Well starting this month we want to share our excitement with you. We will showcase our favorite features (typically one to two) with you, with the aim to give you a few more ways to use the new features.