Forecasting money

[myou]

Hello,

I am facing difficulty in preparing this report

I have this table with different measures

Project1	Remaining Balance	AVG
ABC	100	30

I want to add extra columns to it where I forecast the money for 2020

Jan-20

Feb-20

Mar-20

Apr-20

May-20

Jun-20

Jul-20

Aug-20

Sep-20

Oct-20

Nov-20

Dec-20

AVG

30

30

30

10

Remaining

100

70

40

10

Each month I am subtracting Remaining-AVG

then at the end I check if AVG<Remaining , then Remaining

[v-chuncz-msft · Accepted solution]

@myou 

Add a calendar table and use the matrix visual. You may refer to the .pbix attached.