Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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,


Super User
Super User

Hi @ohurtado see example on link  hope this help

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.