Calculate differences between budget versions

[hideakisuzuki01]

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.  

[v-deddai1-msft · Accepted solution]

Hi @hideakisuzuki01 ,

You can create two new slicer table:

slicer1 = SELECTCOLUMNS('Table',"Year",'Table'[Year],"Version",'Table'[Version])
slicer2 = slicer1

Then 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

[amitchandak]

@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])