I have been tasked with creating a report in Power BI for a project that we’re doing at workplace. So, what we’re doing at work is having a price increase for our products in August.
Now, using all products, I have created a ‘total revenue’ measure. This is just the revenue we are ‘expecting’ for August - the ‘best case scenario’ i.e. no attrition. (But I’ll get to attrition later).
Next, what I want to do is assuming there’s no attrition, I’ll have the same revenue for all the months till the end of the financial year. How do I do this? I can create a ‘date-table’ that goes up to June 2020. What measure can I create to populate the revenue for these months the same as total revenue for August?
Once that’s done, I also want to create a ‘cumulative total’ till June 2020.
Finally, I want to create a ‘what-if’ parameter for the initial attrition only in August. So, when I adjust the slider on the ‘attrition visual’, it will affect the cumulative revenue as well!
Many thanks for your help on this, guys!