Rolling AVG when there is missing data

[Xpazpor91]

I have a pivot table and I’m trying to calculate the 3 month average. Some users may have a blank for the month and the windowAVG function wasn’t working when there was missing data. I tried a different formula but it is still not working. For example Claudio had values for December and November.

(lead (({DL_calc}), [AvgSaleDate DESC], 2,[fieldman]) +lead (({DL_calc}), [AvgSaleDate DESC], 1,[fieldman])+ ifelse({DL_calc} = NULL,0,{DL_calc}))/3

[Max]

Have you looked at this?

Rolling Average calc for use in line chart

I would like to create a rolling average calculation to use in a line chart. The functions runningAverage and windowAverage do not fit my use case. I want to create a calculation that averages {field} for rows with {OM Date} <= {date} and {OM Date} >= {date}-30days. In my dataset, not all days appear in {OM Date}, which is why runningAverageandwindowAverage` do not fit my use case. The closest I have gotten to a solution is creating a date parameter and plugging it into a calculation and x-axi…