Forum Discussion
Solved
Previous Month from January
Not a new issue and shocking that it still hasn't been resolved. I posted this under issues already but if anyone has a workaround that actually works I would be most grateful. If you have a PBI re...
Hi jtma508 ,
It works fine on my side.
Sales Prev MO = CALCULATE(SUM('Table'[value]), PREVIOUSMONTH('calendar'[date]))My Power BI Desktop version is December 2021. Try upgrading your application and check again.
Or you could try using below formula:
Sales Prev MO = CALCULATE(SUM('Table'[value]), FILTER(ALLSELECTED('Table'),FORMAT('Table'[date],"YYYYMM") = FORMAT(EDATE(SELECTEDVALUE('calendar'[date]),-1),"YYYYMM")))Best Regards,
Jay
Hi jtma508 ,
It works fine on my side.
Sales Prev MO = CALCULATE(SUM('Table'[value]), PREVIOUSMONTH('calendar'[date]))
My Power BI Desktop version is December 2021. Try upgrading your application and check again.
Or you could try using below formula:
Sales Prev MO = CALCULATE(SUM('Table'[value]), FILTER(ALLSELECTED('Table'),FORMAT('Table'[date],"YYYYMM") = FORMAT(EDATE(SELECTEDVALUE('calendar'[date]),-1),"YYYYMM")))
Best Regards,
Jay