Forum Discussion

Helper I

6 years ago

Solved

Comparing same periods from last year

Hi!

I would like to compare periods from last year in a graphic like this considering the day of the week so i compare Monday 2020 vs Monday 2019:

The lines of the graphic should be one over the other like if it was the same period.

Thanks!

ryan_mayu
6 years ago
Miguelcrz
if you have a calendar table, you can also try this
create a meausre
Last year = CALCULATE(sum('Table'[sales]),DATEADD('datetime'[Date],-1,YEAR))
create a line chart
add last year measure to filter and choose is not blank

3 Replies

amitchandak
Super User
6 years ago
Miguelcrz , Last year same week day 364 days behind

Year week behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,Day))

Also check

Power BI — WTD Questions— Time Intelligence 4–5
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
Power BI — Day Intelligence Questions — Time Intelligence 5–5
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
ryan_mayu
Super User
6 years ago
Miguelcrz
you can try create a year column in table.
year = year('Table'[Date])
Then create a line chart
ryan_mayu
Super User
6 years ago
Miguelcrz
if you have a calendar table, you can also try this
create a meausre
Last year = CALCULATE(sum('Table'[sales]),DATEADD('datetime'[Date],-1,YEAR))
create a line chart
add last year measure to filter and choose is not blank

Related content