Intraday Rolling Average

[Borednlost]

Hi all,

I'm very new to PBi and am trying to calculate SLA adherence at a call centre during a day.
My data has the % of calls handled in SLA by 30min interval, but all the rolling average solutions I've seen use 'DATESINPERIOD'.  A days data looks like:

Intervals	SLA	Expected Result
7:00:00 AM	100	100
7:30:00 AM	100	100
8:00:00 AM	86	95.33333333
8:30:00 AM	17	75.75
9:00:00 AM	39	68.4
9:30:00 AM	56	66.33333333
10:00:00 AM	7	57.85714286
10:30:00 AM	0	50.625
11:00:00 AM	6	45.66666667
11:30:00 AM	0	41.1
12:00:00 PM	0	37.36363636
12:30:00 PM	0	34.25
1:00:00 PM	0	31.61538462
1:30:00 PM	33	31.71428571
2:00:00 PM	0	29.6
2:30:00 PM	0	27.75
3:00:00 PM	100	32
3:30:00 PM	93	35.38888889
4:00:00 PM	0	33.52631579
4:30:00 PM	0	31.85
5:00:00 PM	0	30.33333333
5:30:00 PM	50	31.22727273
6:00:00 PM	80	33.34782609
6:30:00 PM	100	36.125
7:00:00 PM	100	38.68
7:30:00 PM	100	41.03846154
8:00:00 PM	100	43.22222222
8:30:00 PM	100	45.25

[amitchandak]

@Borednlost , If Interval is datetime column then try a new column

new column =
avergageX(filter(Table,[interval] >earlier([interval]) -time(23:59:29) ),[SLA])

[kumar27]

can you expain a bit more? do you want to use datesinperiod ? or the goal is to get the rolling average as in column C?