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.
Tag: DAX
Power BI Brain Candy: Value Above Replacement
In today’s article, I’m aiming to achieve three overlapping goals:
Using Dax To Handle Multiple Parent Hierarchies
A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries.
Automated Testing Using Dax for Power BI
How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right?
Using Dax to create a KPI
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper.
Dax: Back to the basics
For me, whenever I am new to a concept, and I read a statement like the one above, I often say “Well that’s great, but just what does that mean?” I am a big believer in mental models or ways of visualizing the flow of execution.
Convenience Filters In SSAS Tabular Models
Think back to the year 2012 when Microsoft introduced us to SQL Server Analysis Services Tabular models.
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
Disconnected Slicers With DAX Variables & SELECTEDVALUES
Hello P3 Adaptive Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots.
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.
March Madness in Power BI
It’s time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI.
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.
- 1
- 2