Calculation Groups to the Rescue!
o set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.
Category: Common DAX Functions
Speed up your Power BI DAX formulas by up to 95% using the new OPTIMIZEDAX() function
This is an April Fools’ joke. OPTIMIZEDAX() doesn’t exist, but we hope the post gives you a laugh nonetheless.
Navigating DAX Function Types: A list of DAX Scalar and Table functions
Let’s start off today’s post with a pop quiz. Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer
Using DAX Magic For Variable Forecasting
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection.
The Great Function Project – Part 1
P3 Adaptive has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success.
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Coffee Talk: DAX Pros
n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).
DAX – The Great Precedence Project (Filter Rules for DAX)
“Wait a minute. There might be legal precedent. Of course. Land snatching. Let’s see, land, la-land…see snatch. snatch…snatch…ah! Haley vs. United states. Haley 7, United States nothing. You see, it can be done!
Power BI and Power Pivot DAX: CALCULATE is a supercharged SUMIF
“No [doubt] she’ll freak. I’m just contemplating the =IF()’s…” -Marcellus Wallace, obvious master of the spreadsheet arts CALCULATE is a supercharged SUMIF I can’t believe I didn’t say this last […]