Forecast Last 6 Months using the last forecast

[luismolle]

Hi! Im struggling with forecasting in Power BI.
I have a table with dates, Attributes and amounts. My idea is to calculate the amount for the nexts months based on the last 6 values I have. For the next the calc should consider the 5 actual months and the forecast done, for example:

(dummy data)

in this case, april should be the average of the last six months, and May should be the average of last five filled and April that was just calculated.

[Anonymous]

Hi @luismolle ,

Regarding your question, this is an iterative calculation. That is, the value of the current row is based on the result of the calculation of the previous row. This cannot be achieved in DAX. It is recommended that you use Power Query M code.

List.Accumulate - PowerQuery M | Microsoft Learn