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: DAX
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
Reducing DSO using Power Pivot
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
Power Pivot Cracks Direct Method Cash Flow Conundrum
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers.
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.