new measure which calculates difference between consecutive years.

Question

Hi,I have below measure named "Total" and a date column.Total is addtion of all the columns present in Sheet1.&nbsp;&nbsp;Total = SUMX(Sheet1, Sheet1[Ambulances] + Sheet1[Arti.&amp; Multi.Veh] + Sheet1[Autorickshaw] + Sheet1[Cars] + Sheet1[Contract Carriage] + Sheet1[Del.Van (3W)] + Sheet1[Del.Van (4W)] + Sheet1[jeeps] + Sheet1[Mopeds] + Sheet1[Motor Cycle ] + Sheet1[others] + Sheet1[Pvt.Ser.Vehicles] + Sheet1[School buses] + Sheet1[Scooters] + Sheet1[Stage Carriage] + Sheet1[Stn.Wagons] + Sheet1[Tankers] + Sheet1[Taxies Cabs] + Sheet1[Tractors] + Sheet1[Trailers] + Sheet1[Trucks &amp; Lorries])I need a new measure which calculates difference between consecutive years.How do I do that?&nbsp;&nbsp;Also there are any tutorials to practice such basic calculations which helps to explore and understand various DAX functions?

v-yulgu-msft · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
Please try this measure:
difference between consecutive years =
[Total]
    - CALCULATE (
        [Total],
        FILTER ( ALL ( Sheet1 ), Sheet1[Date] = MAX ( Sheet1[Date] ) - 1 )
    )

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

new measure which calculates difference between consecutive years.

2 Replies

Related content

Dynamic Calculation Different Period

Calculating difference between consecutive rows

Calculate difference between consecutive rows / columns

Different Calculations

Calculating difference between consecutive rows