Forum Discussion

ohurtado's avatar
ohurtado
Frequent Visitor
3 years ago

Forecasting data based on a % increase

Hi all, very new to DAX coding here, so looking for some help as I'm not sure how to go about this...

In short I'm trying to forecast values of a certain "index/seriesID", given 2 things:

1) On one table I have historical data of all indexes (seriesID, date, value)

2) On another table I have amongst other things, the rate at which this index is expected to grow for the next 5 years (5 different columns for each year -> seriesID, Y+1 growth, Y+2 growth, Y+3 growth, etc

I would like to have a graph that shows all the historical data and then using last known value, show (ideally in a different colour), what would be the expected growth for this index.

 

What would be the way to calculate this in DAX and then, can these values be shown together in the same graph, while making a distinction between what are facts and what is forecast?

 

Best regards,

OScar