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!