Tag: Scenario Analysis

Develop Advanced Scenario Analysis Models Using DAX in Power BI

Develop Advanced Scenario Analysis Models Using DAX in Power BI

I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favorite technique to use, mainly because it can be so valuable to the business. Rather than just

Continue reading

Predicting Future Results – Next Free Power BI Training Workshop

Predicting Future Results - Next Free Power BI Training Workshop

In the next free Power BI training workshop being put on by Enterprise DNA we are going to be diving deep into some prediction analysis. You can learn more and register for the event here Predicting Future Results in Power BI What I wanted to do was take a very real-world situation and look to

Continue reading

Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is

Continue reading

How To Start Using ‘What If’ Parameters Inside Power BI

How To Start Using 'What If' Parameters Inside Power BI

In this tutorial, I will show you how you can get started with ‘What If’ parameters inside of Power BI. Using this great feature will require you to spend some time thinking quite deeply about the data setup that you currently have in your data model. ‘What If’ parameters have to work over certain values

Continue reading

Deep Dive Into The TREATAS Function – Virtual Relationships For Power BI

Deep Dive Into The TREATAS Function - Virtual Relationships For Power BI

In this example, I dive into one of the most advanced DAX functions in Power BI┬ácalled TREATAS. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you might be creating inside of Power BI desktop. TREATAS will helps greatly in the simplification of

Continue reading