Forecast Triangle in PowerBI

[Anonymous]

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

	January	February	March	April	May	June	July	August	September	October	November	December
January	25	24	21	22	23	24	25	30	31	33	32	25
February	25	23	24	25	22	33	22	15	20	15	27	18
March	25	23	23.5	22	22	22	21	21	20	20	21	22
April	25	23	23.5	24	23	22	20	33	22	33	22	40
May	25	23	23.5	24	22.5	12	10	11	12	25	30	20
June	25	23	23.5	24	22.5	0	0	0	0	0	0	0
July	25	23	23.5	24	22.5	0	0	0	0	0	0	0
August	25	23	23.5	24	22.5	0	0	0	0	0	0	0
September	25	23	23.5	24	22.5	0	0	0	0	0	0	0
October	25	23	23.5	24	22.5	0	0	0	0	0	0	0
November	25	23	23.5	24	22.5	0	0	0	0	0	0	0
December	25	23	23.5	24	22.5	0	0	0	0	0	0	0

[lbendlin]

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

[Anonymous]

 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.