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
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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
munchkin666
Helper II
Helper IIv-danhe-msft such a simple formula and works like a charm 🙂 thank you!