Jittered Scatter Charts in Power BI via DAX and Power Query
In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. T
Content Type: Blog Post
Power Query (M)agic Part 3: Divide & Conquer
Welcome back P3 Adaptive Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting!
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
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.
Interview with Chris Finlan on Power BI Report Server
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 […]
Coffee Talk: The Tabular Pros
Ok so we missed a week. We had a busy training in Denver last week. Good news is we’re baaaaaaaaaack and with a great lineup of Tabular Pros.
DAX Reanimator Series: Top Performers using SUMMARIZE
Welcome back P3 Adaptive 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 […]
Chatting with John Michaloudis & Rob Collie
The #1 Supporter of our 2nd Edition Book Sits Down for a Virtual Interview
Power BI Feature Spotlight: Report Drill Through
Every month Power BI gets an update that adds a nice handful of new features. Here at P3 Adaptive we ALL get excited for new Power BI features!
DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
Power BI (DAX and M) vs. R: A Summer of Perspective
Based on what I’ve learned from Zoe, and what I’ve read to fill in the gaps, I think the two big differentiators are “how much statistical rigor do you require” and “how many different variations of the question do you need to ask?”
AutoExist, Cross Table Filtering, and You
The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table. Also, Cross Table Filtering…
The Difference Between Forecasting & Predictive Analytics
Forecasting is when we anticipate the behavior of lots of people on long timelines. Predictive Analytics anticipate the behavior of One person…