Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
sorry if this is a repeated question. I went through few other threads that looked similar, but still haven't been able to work it out. I am new to Power BI and still getting my head around the wonderful tool. Any help appreciated.
What I want to achieve
Prepare a financial forecasting tool that will update the future outlook based on altering the assumptions about varioud things (screenshot attached).
What I have done
I created a single table that includes the Years that I want to include in the report.
Added bunch of What-if parameters that will be used to play with the forecasts
Then everything else is measure calculated with PRODUCTX() on that table.
For example, Annual Revenue formula is as below:
Year Revenue = PRODUCTX( 'Finance Forecast',
'Base Revenue'[Base Revenue Value] * POWER(1+[Expected Growth Rate Value], 'Finance Forecast'[Year Index]-1) )
Financial Forecast table is as below:
Questions:
Solved! Go to Solution.
Hi,
Does this work?
=IF(HASONEVALUE([Year]),[Year Revenue],SUMX(SUMMARIZE(VALUES([Year]),[Year],"Rev",[Year Revenue]),[Rev]))
Hi,
Does this work?
=IF(HASONEVALUE([Year]),[Year Revenue],SUMX(SUMMARIZE(VALUES([Year]),[Year],"Rev",[Year Revenue]),[Rev]))
Thanks for quick respond @Ashish_Mathur
That did the trick 🙂
I combined the two in one measure as below:
Year Revenue = IF(HASONEVALUE(Years[Year]), PRODUCTX( 'Years', 'Base Revenue'[Base Revenue Value] * POWER(1+[Expected Growth Rate Value], 'Years'[Year Index]-1) ), SUMX(SUMMARIZE(VALUES(Years[Year]), Years[Year], "Rev", PRODUCTX( 'Years', 'Base Revenue'[Base Revenue Value] * POWER(1+[Expected Growth Rate Value], 'Years'[Year Index]-1) ) ), [Rev]) )
and now trying to digest what just happened haha
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |