Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Forecast Triangle in PowerBI

Hello PowerBI Forum,

 

I need help creating a forecast triangle in PowerBI, I'm not sure how I should structure the data in excel.
The idea is that we do a monthly forecast for the next 12 months, then when we get the actual result. We are trying to compare to our original result to determine how accurate we are.

 

Vertical data = actual result

Horizontal data = forecast result

 

Example- row 1- January - we forecast the next 12 months and February is estimated at 24.

                row 2- the actual the result for February is 23, then we forecast out 11 months

 

 JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
January252421222324253031333225
February252324252233221520152718
March252323.5222222212120202122
April252323.5242322203322332240
May252323.52422.512101112253020
June252323.52422.50000000
July252323.52422.50000000
August252323.52422.50000000
September252323.52422.50000000
October252323.52422.50000000
November252323.52422.50000000
December252323.52422.50000000

2 Replies

  • where are the forecast weights coming from? Why the hole starting from June?

    • Anonymous's avatar
      Anonymous
      Not applicable

       Hi Ben, The forecast weight comes from a system. In this case, I use mock data to illustrate my visual. 
      The hole begins in June is essentially when we stop updating our spreadsheet.