Data Analytics Made Easy: Download Our Power BI DAX Reference Card
Let’s be honest, working with DAX can sometimes feel like a puzzle, right? Even if you’re a seasoned Power BI user, there are moments when you’re knee-deep in calculations and […]
Category: DAX
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.
A Brief Treatment of DIVIDE(), RANKX(), and “N/A”
Ya know, we could probably write articles about RANKX for an entire year. There are just SO many subtleties to it, and SO many different ways you might want to rank things. Endless source of blog fodder.
Power BI Brain Candy: Value Above Replacement
In today’s article, I’m aiming to achieve three overlapping goals:
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
Export Power BI Data with Date Range in Title
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a […]
Setting a Default Slicer Selection
I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports
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.
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