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 inside of your data sets so the overall setup of your model is very important.
You need to think about how you can incorporate logic inside of DAX measures or calculations you are already running inside of your models. Examples of this could be things like increasing or decreasing sales demand or price.
We have to find the elements in your data sets which you need and want to shock or adjust.
Take it from me, if you can combine all of these things, this is some of the most powerful analysis that you can do inside Power BI.
With ‘What If’ parameters, you can almost predict things that might have happened or will happen in the future.
Being able to complete this type of analysis at scale within Power BI is so powerful. I highly recommend diving into how you can utilize not just this feature but many other techniques that go into implementing ‘What If’ parameters inside your analysis.
There’s certainly lots to learn, lots to review and also plenty you can replicate in your own environments.
All the best!
***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online