Show Data from last year

[AnnJ2209]

Hi,

I am trying to get the data for same month last year, but how do I do that when I have filter on that I only show current month (relative date). 

I just want to ad turnovers from the same month last year? 🙂 

[amitchandak]

@AnnJ2209 , Try time intelligence with date table

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('dateadd('Date'[Date],-11,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))

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