Forum Discussion
Calculate differences between budget versions
Hi there
I have yearly budget/forecast data, and we have a new version every 3 months. For example,
Year, Version, Amount
2021, 20-11, $1200
2021, 21-02, $1000
2021, 21-05, $1100
And I want users to choose two versions and display the differences in a bar chart. It would be great if the users can choose versions using slicers but I dont know if that is possible.
If there are ways other than using slicers then that works too.
Hi hideakisuzuki01 ,
You can create two new slicer table:
slicer1 = SELECTCOLUMNS('Table',"Year",'Table'[Year],"Version",'Table'[Version]) slicer2 = slicer1Then you can create two measure:
Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer2[Version]))) Measure1 = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer1[Version])))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
2 Replies
hideakisuzuki01 , In this case, you need two independent tables with version or version and year. Then you need to use them to filter data to compare.
refer to my date range blog on a similar topic
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
New table 1 = summarize(Table, [Year], [Version])
New table 2 = summarize(Table, [Year], [Version])
Hi hideakisuzuki01 ,
You can create two new slicer table:
slicer1 = SELECTCOLUMNS('Table',"Year",'Table'[Year],"Version",'Table'[Version]) slicer2 = slicer1Then you can create two measure:
Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer2[Version]))) Measure1 = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer1[Version])))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
