Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |