Moving Average in Custom Timescale
I have a scenario where I'm trying to calculate the moving average from actuals in Custom Day time scale. In a module, I have sales data to be uploaded, from the sales data I have to calculate the moving avg of 90 days at the day level. Dimension in the module Article, Custom Day scale. Line Item -Sales Qty, Sales Value.
I tried using the formula -
Line item 1- CUMULATE(Sales Qty, FALSE, Custom Day)) / 90
Line Item 2- 'Line Item 1' - 'Line Item 1'[LOOKUP: Custom Day.'Current Day-90']
The Above formula gives average but not moving average. Any suggestions, please?