Forum Discussion
Finding difference in values for the same category
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)?
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/
2 Replies
- Jihwan_Kim
Super User
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)))
