Forum Discussion
Solved
Time Difference between Rows Grouped by Location, Averaged over Last 7 Days
I'm brand new to BI so please be patient. What I would like to achieve is a rolling average of the time between arrivals of technicians to a location over the previous 7 days. EX: This is the...
Assume you have date time entry or create by merging date nad time
time diff = datediff(table[Datetime], maxx(filter(table,table[geofencse] = earlier(table[geofencse]) && table[Datetime]<earlier(table[Datetime])),table[Datetime]),Hour)
Create as new column. Seems like you are creating like new a new measure
Thank you for being so patient. I am clueless here.