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

[Anonymous]

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

[v-easonf-msft · Accepted solution]

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

[Anonymous]

Thanks for your suggestion, it's working fine