Solved: Test

StevesHelp · ‎01-09-2018

MarkLaf · ‎01-09-2018

You can create a measure with the filter you want and use it for the data in your graph. Something like this should work:

Forecast+/-5wks:=CALCULATE(SUM(Sales[Forecast]),FILTER(Sales,Sales[WeekDate]<=TODAY()+35 && Sales[WeekDate]>=TODAY()-35))

If you need exactly 5 weeks before and 5 after, you can replace the TODAY()'s with TODAY()-WEEKDAY(TODAY(),3))

If your data isn't already aggregated by start of week, you can use the minus weekday formula just noted to add a calculated column to use as your x-axis.

View solution in original post

MarkLaf · ‎01-09-2018

You can create a measure with the filter you want and use it for the data in your graph. Something like this should work:

Forecast+/-5wks:=CALCULATE(SUM(Sales[Forecast]),FILTER(Sales,Sales[WeekDate]<=TODAY()+35 && Sales[WeekDate]>=TODAY()-35))

If you need exactly 5 weeks before and 5 after, you can replace the TODAY()'s with TODAY()-WEEKDAY(TODAY(),3))

If your data isn't already aggregated by start of week, you can use the minus weekday formula just noted to add a calculated column to use as your x-axis.