Category: DAX

Layering Multiple ‘What If’ Scenarios Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading

Latest FREE Workshop Announcement – Effective Power BI Reporting

The last Enterprise DNA free workshop session was a really great event, so I’ve decided to run another one before the end of this month. During this next session – Effective Power BI Reporting – I’ll be running through many of my best practice techniques around building valuable Power BI solutions. Now this doesn’t just

Continue reading

Introducing Forecasting Logic Into Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading