Forum Discussion
Intraday Rolling Average
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 solut...
amitchandak
Super User
Super UserBorednlost , If Interval is datetime column then try a new column
new column =
avergageX(filter(Table,[interval] >earlier([interval]) -time(23:59:29) ),[SLA])