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
Category: DAX
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.
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 […]
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.
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…
DAX Reanimator Series – Part 3: Compare Product Performance After Launch
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.
DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers
Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.
M/Power Query “Sets Up” DAX, so Learn DAX (and Modeling) First
You should advance to Intermediate in DAX before advancing to Intermediate in Power Query / M, and then to Mastery of DAX before Mastery of M.
Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
First off…my first post! Being one of the newest (and youngest) members of the P3 Adaptive family has been very exciting so far. As a way of introducing myself, I’d like to share a creative solution to a problem I’m sure many of you have encountered when building a report or dashboard.
Rediscovering (fire)matting: a truly amazing BI “tool”
This automatic BI tool has saved me innumerable hours each month and I find this useful for at least 80% of my DAX formulas.