Forum Discussion

allwin_1510's avatar
allwin_1510
Frequent Visitor
7 years ago

Difference between current month and previous month

  I am trying to calculate the difference of AHT between the two months for different categories. The AHT displayed is already a measure and i am using a month slicer to filter the data as per month...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, allwin_1510

What is your data structure? do you mean that you select two months then calculate the difference between two months?

If so, if you select three or more months, how to calculate the difference?

 

if not, do you mean that calculate difference between two consecutive months?

you could create a date table then use PREVIOUSMONTH  to create a measure bease on [AHT]

like 

difference = CALCULATE([AHT],PREVIOUSMONTH('Date'[Date]))
 

If it is not your case, please share sample pbix file or some data sample and expected output . You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Best Regards,

Lin