Forum Discussion
Finding difference in values for the same category
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/
Super Usermusafasih , 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)))