topic Could you please help me to get the Forecast values through the DAX calculation in DAX Commands and Tips

Could you please help me to get the Forecast values through the DAX calculation

Anonymous — Tue, 21 Jun 2022 15:20:06 GMT

Please find the below screenshot, it has information like the Date and Quantity columns.
So there I should get the Quantity values for the date column between '7/1/2022' to '4/1/2023'

We should get the average for the last 12-months Quantity ----- 12-Months QTY/12
12-Months QTY/12---It should be in '7/1/2022' .......... 12-Months QTY/12---It should be in '4/1/2023'

Please find the below screenshot for your understanding purposes, there highlighted with color, so that highlighted values how we get it

Thanks
Kiran

Re: Could you please help me to get the Forecast values through the DAX calculation

v-easonf-msft — Fri, 24 Jun 2022 09:36:57 GMT

Hi, Anonymous

For now, DAX is not suitable for this kind of iterative operations. If possible, please processe this part of the data preferentially in excel and then imported into PowerBI.

Best Regards,
Community Support Team _ Eason

Re: Could you please help me to get the Forecast values through the DAX calculation

Anonymous — Mon, 27 Jun 2022 07:12:51 GMT

Thanks for your suggestion, it's working fine