Forum Discussion

hideakisuzuki01's avatar
hideakisuzuki01
Helper II
5 years ago
Solved

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,   ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

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