Rob Slavin

TL;DR If you want to create a Rolling Average in Power Bi using DAX, skip to here Why Rolling Average A common task I have is to analyse the performance of automated warehouses. This might involve monitoring how many cartons pass by on a conveyor or counting how many cartons are palletised by a robot. When dealing with time series information like the number of cartons per minute, the data can be quite noisy, particularly if you have slugs (groups) of cartons moving together with large gaps in between.