https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Forecast-Last-6-Months-using-the-last-forecast/m-p/4007751#M157060 <P>Hi! Im <SPAN>struggling&nbsp;</SPAN>with forecasting in Power BI.<BR />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:<BR /><BR /></P><P><img /></P><P>(dummy data)<BR /><BR />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.</P> Mon, 24 Jun 2024 21:16:43 GMT luismolle 2024-06-24T21:16:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Forecast-Last-6-Months-using-the-last-forecast/m-p/4007751#M157060 <P>Hi! Im <SPAN>struggling&nbsp;</SPAN>with forecasting in Power BI.<BR />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:<BR /><BR /></P><P><img /></P><P>(dummy data)<BR /><BR />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.</P> Mon, 24 Jun 2024 21:16:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Forecast-Last-6-Months-using-the-last-forecast/m-p/4007751#M157060 luismolle 2024-06-24T21:16:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Forecast-Last-6-Months-using-the-last-forecast/m-p/4008201#M157302 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="609485" data-lia-user-login="luismolle" class="lia-mention lia-mention-user">luismolle</a>&nbsp;,</P> <P>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.</P> <P><A href="https://learn.microsoft.com/en-us/powerquery-m/list-accumulate" target="_blank">List.Accumulate - PowerQuery M | Microsoft Learn</A></P> <P>&nbsp;</P> Tue, 25 Jun 2024 04:42:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Forecast-Last-6-Months-using-the-last-forecast/m-p/4008201#M157302 Anonymous 2024-06-25T04:42:22Z