Line graph, add second line with last week's data?

[Anonymous]

I have a line graph that displays speed for the past 7 days. How do I add a second line that shows speed for the same days of the previous week?

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

My sample table:



Please create measure using the formula below. Create a table visual to display the result, check if it's correct.

speed for the same days of previous week = CALCULATE(SUM(Table1[speed]),DATEADD(Table1[Date],-7,DAY))

Beside your "speed for the past 7 days" measure, then add it as value level in line Chart, we can add mutiple measure as value levels in line chart.


Best Regards,
Angelia