Forum Discussion

Binway's avatar
Binway
Icon for Helper II rankHelper II
8 years ago

Current Month Calc, forecast and Pro rate

Hi Folks, I a financial year starting in April where I need to calculate the current months average for the previous 3 months and forecast to the end of the year, but with the current month showing ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Binway

 

It seems you may need a calendar date table. If it is not your case, please share some data sample file. You can upload it to OneDrive or Dropbox and post the link here.

 

Regards,

Cherie

Binway's avatar
Binway
Icon for Helper II rankHelper II
8 years ago

Hi Cherie,

You may get a better view from the PBIX file - hopefully you can see it.

Avg Forecast Rpt

I have broken the calculations down and put them in the matrix along with what would be the final field which presents correctly but the calcualtion is not the average of the previous 3 mths.

 

 

Thanks Binway