Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

new measure which calculates difference between consecutive years.

Hi, I have below measure named "Total" and a date column. Total is addtion of all the columns present in Sheet1.     Total = SUMX(Sheet1, Sheet1[Ambulances] + Sheet1[Arti.& Multi.Veh] + Sheet1[A...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Please try this measure:

    difference between consecutive years =
[Total]
    - CALCULATE (
        [Total],
        FILTER ( ALL ( Sheet1 ), Sheet1[Date] = MAX ( Sheet1[Date] ) - 1 )
    )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please try this measure:

difference between consecutive years =
[Total]
    - CALCULATE (
        [Total],
        FILTER ( ALL ( Sheet1 ), Sheet1[Date] = MAX ( Sheet1[Date] ) - 1 )
    )

 

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Yuliana,

I am very sorry delayed response.

 

I tried two different measures for calculation. Is it good practice to use different measures? How do I optimize it further?

 

Measure suggested by you is not working for me. I wonder where I went wrong. Could you have a look at my file?

 

https://drive.google.com/open?id=1b4oPzUdB0LWDv6YOgj4ligmJLNTgUcsi