Forum Discussion

SuperCal99's avatar
SuperCal99
Helper I
4 years ago
Solved

Calculate % difference between two years

I would like to work out % difference between 2 years for a set of values and having some trouble doing so.   First of all, let’s say I have the following sample of data   Year Fruit Name ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SuperCal99 , You need create a separate year table(say Date) and the create a measure like

     

    example

    This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
    Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

     

    diff = [This Year]-[Last Year ]
    diff % = divide([This Year]-[Last Year ],[Last Year ])

amitchandak's avatar
amitchandak
Super User
4 years ago

SuperCal99 , You need create a separate year table(say Date) and the create a measure like

 

example

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

 

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])