Self-service data analysis with Microsoft Power BI.
Slicers are Empowering! There have been several blogs and articles written on dynamic measures and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers. See here & here. These techniques are popular…
I remember feeling that way, Mr. Badger, but they’re simple… if you can SEE them! Have you ever needed to SUMX() over the values in more than one column? SUMMARIZE() can do it! I tried solving this problem and the…
Real-World Dashboard for Disaster Monitoring / Planning / Acting Intro from Rob: It’s all About Action! Informing people is worthless. When working with clients or students, I like to challenge them with this seemingly-controversial statement: Informing people is worthless. Then…
Over the summer PowerPivotPro achieved our Microsoft Partner Gold Competency in Data Analytics. As part of our increasing focus on our partnership with Microsoft we invited Tamer Farag, the Global Partner Ecosystem Lead for Power BI, PowerApps and Microsoft Flow…
Wham! It's a hands-on technique! In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. That future starts today! And while I certainly have enjoyed writing my more…
How Far Down The Rabbit Hole Will You Go? 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…
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. In Part One, I used What-if-parameters…
The Man, The Myth, The On-Prem Server Guy… Chris Finlan and I have known each other for some time now. He emailed me out of the blue 3.5 years ago and we’ve been in touch ever since. In 2014 he…
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…
Oh My Goodness Yes. A Thousand Times Yes. (Scroll Down for the Interactive Versions) A Formerly Six-Figure Project Becomes “Free” While Also Becoming MUCH BETTER In a former life (circa 2006), I got to spend several hundred thousand dollars of…