How calculate forecast on YTD with the last values

[Cobra77]

Hi ,

how to calculate a kind of forecast based on the last value of the month with data ?

Take for example with this dataset :

we would like to have this YTD + forecast measure, which recovers the last existing monthly value and adds it up each month, dynamically.

thanks for your help

[Manish0664]

 

 how I calculate measure for this????

Need actual 2023 then remaining forecast

[v-diye-msft · Accepted solution]

Hi @Cobra77 

Please kindly add the calculated column in calendar table:

Monthnum = MONTH([Date])

and then add the measure:

Measure = var a = MAX('Calendar'[Monthnum])-6
Return
IF([Sales YTD]=BLANK(),20*a+[Sales (YTD) basic],[Sales YTD])

[v-diye-msft]

Hi @Cobra77 

You need to add the index column and create a measure. please kindly share your simple worksheet/dummy pbix, I'll draw it up for you.

[Cobra77]

Hi @v-diye-msft ,

https://1drv.ms/u/s!AmluE3Tt6h4WaZP6pyjYMsbx7vs?e=hxykkE

Thanks