Finding difference in values for the same category

[musafasih]

My dataset has 3 columns: vehicle registration, month and year, and kilometers. How can I develop a measure which allows me to find the difference in kilometres between consecutive months for the same vehicle (with the same registration number)?

[Jihwan_Kim · Accepted solution]

Hi, @musafasih 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

It is better to have Dim Caledar Table separately.

All measures are in the sample pbix file.

https://www.dropbox.com/s/jkl2iwnhfn6ccgq/musafasih.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@musafasih , Best is create a date like

date([year], [month],1) , then join with date table and create measures likes

example

MTD Sales = CALCULATE(SUM(Table[kilometers]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Table[kilometers]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))