Formula is not working. Month -1, Month -2 etc.

[PeterNowak]

Hello,

I prepared a dashboard in PowerBI desktop which is live connect to SQL server.

I used below formula to get data for previous month, month -2 etc, but after the year changed it looks like it's not working.

Could you guys help me how should I prepare the formula to show the data from previous months?

Right now it looks like that:

"Requested Date Time'[Requested Date (Month Number)]= MONTH(TODAY())-1"

[AlB · Accepted solution]

Hi @PeterNowak 

Try

 MONTH ( EDATE( TODAY( ), -1) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak]

@PeterNowak . If you have a date you can use the date table and time intelligence

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Also check Why Time Intelligence fails - https://www.youtube.com/watch?v=OBf0rjpp5Hw