Tag: Scenario Analysis

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

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

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

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

Predict Future Profitability within Power BI Using DAX

In this video tutorial, I will showcase some of the analytical work I enjoy completing the most in Power BI..that is working on future predictions.¬† I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future profitability and one that

Continue reading