Forum Discussion
Solved
Previous month and Current month values are same
I'm building a report, the matrix should show current and previous month figures. When i tried both current and previous columns show same values. I have tried multiple ways for the calc...
Hi prvn ,
Based on my test, you could refer to below formula:
Measure = CALCULATE(SUM(Table1[Active]),PREVIOUSMONTH('Calender'[Date]))Result(note to use calender date as date):
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks for the respose. Will this solution work if there is data missing for weeks in between?
I was unable to open the pbix as i need to update power bi app. I'm currently using 2.67.
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi prvn ,
Yes, it could work for your data. You could also refer to below link about how to use previousmonth function:https://docs.microsoft.com/en-us/dax/previousmonth-function-dax
If it could not help you, you could upload your pbix file to have a test.
Regards
Daniel He