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!
Welcome back P3 Adaptive Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting!
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.
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 […]
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.
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 […]
The #1 Supporter of our 2nd Edition Book Sits Down for a Virtual Interview
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 Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
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?”
The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table. Also, Cross Table Filtering…
Forecasting is when we anticipate the behavior of lots of people on long timelines. Predictive Analytics anticipate the behavior of One person…
Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.