Forum Discussion
Previous month and Current month values are same
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
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
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
Hi 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
- v-danhe-msft
Hi prvn ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
- munchkin666
Helper II
v-danhe-msft such a simple formula and works like a charm 🙂 thank you!
