How many days left till the used value will reach the target?

[BenNguyen]

Hello Community Team,

I have a question related to the DAX formula. Following is my visualization.
I have a line chart showing comparison between Actual and Target with:
EPZ = external (in yellow), IPZ = internal (in blue)
Prod used = actual (changing by day), Prod Capacity = target (stable data)

By using this line chart, I can see data is growing in each EPZ or IPZ.

But I want to have a card to predict how many days left (counting from the latest date) that the solid line with reach the dashed target line?

Can you please help me out with a DAX formula?
Thank you so much for your support!

[daXtreme · Accepted solution]

Here's some example of how to do such things... File attached. Just scrutinize the file thoroughly and you'll know everything.