Forum Discussion
Dynamic variance calc between multiple financial scenarios
I have Seven different financial scenarios and I am trying to create a variance report to reflect the difference of two scenarios.
Example below:
Budget 24 (will be considered recent) because it was created after the Actual 2023 scenario.
Problem: My Scenario Prior measures do not fully reflected. (for example "Total Current Month potentail" measure return blanks
This is what I did:
1.I duplicated the slicer called "Scenario Recent" and renamed it "Scenario Prior"
2.I created inactive relationship between Scenario Prior and Scenarios2 (see below)
3.I created a dax formula (and this is where I am probably doing something wrong) to ignore the slicer "Scenario Recent" :
4. The"Values Recent" are pulling all measures of the 7 various scenarios and looks like below:
5. Budget 2024 measure looks partially like below:
2 Replies
- DataInsights
Super User
See if you can adapt this solution that uses field parameters:
Thank you for your reply.
The link you sent me was a bit hard to follow.
I used the following link and it worked for me.
Dynamic Variance Analysis with Power BI - Different Forecast Versions Comparison
