Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So I've done some research on rolling averages the last couple days. I've been somewhat successful in coming up with a solution but I'm not quite there. I have a date table and a formula to calculate average wait time, which is measured by averaging up a calculated colum. Here's my formula for the rolling average:
@anonymous123789 , Try something like
CALCULATE (
AVERAGEX ( VALUES ( 'Date Table'[Month] ), [Avg. Wait Time %] ),
DATESINPERIOD ( 'Date Table'[Month], eomonth(MAX ( 'Date Table'[Month] ),-1), -3, MONTH)
)
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |