Posts filed under Intermediate

P3: Using SELECTEDVALUES To Capture Power BI Slicer Selections

Article by: Reid Havens

Data Ambiguity…The Silent Report Killer

Hello P3 Nation, I’m excited to be back and writing a technical post again…it’s been too LONG! Today I want to talk to you about a real-world business problem and solution I encountered last year. I think it’s a scenario at least a few of you will relate to. I was working on a project for a client, and needed to create a Power BI report for them.

Posted on February 1, 2018 and filed under Intermediate, Power BI, DAX, 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.