Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a scenario which requeried rolling forcast for the next three years. Please see the sample data below
Jan-22 | 34.69 |
Feb-22 | 86.72 |
Mar-22 | 64.75 |
Apr-22 | 52.9 |
May-22 | 45.37 |
Jun-22 | 45.9 |
Jul-22 | 47.27 |
Aug-22 | 44.83 |
Sep-22 | 44.86 |
Oct-22 | 43.5 |
Nov-22 | 40.49 |
Dec-22 | 37.69 |
Logic for forecasting is for Jan 23, Average of (Jan 22 to Dec 22)
Feb 23 is Average of (Feb 22 to Jan 23)
Mar 23 is Average of (March 22 to Feb 23)
like this upto Dec 25 we need to iterate. Could you please me to get a solution on this.
Thanks in Advance,
Vishnu
Solved! Go to Solution.
There are probably already some pre-compiled solutions in DAX, but, if you're happy with it, here's something in M.
Thank You so much!!
I didn't see anything in Dax. It will be very helpful if you can send me some.
Best Regards,
Vishnu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.