https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-many-days-left-till-the-used-value-will-reach-the-target/m-p/2854567#M91682 <P>Here's some example of how to do such things... File attached. Just scrutinize the file thoroughly and you'll know everything.</P> Thu, 20 Oct 2022 23:15:20 GMT daXtreme 2022-10-20T23:15:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-many-days-left-till-the-used-value-will-reach-the-target/m-p/2853091#M91552 <P>Hello Community Team,<BR /><BR />I have a question related to the DAX formula. Following is my visualization.<BR />I have a line chart showing comparison between Actual and Target with:<BR />EPZ = external (in yellow), IPZ = internal (in blue)<BR />Prod used = actual (changing by day), Prod Capacity = target (stable data)<BR /><BR />By using this line chart, I can see data is growing in each EPZ or IPZ.</P><P>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?</P><P><img /></P><P>Can you please help me out with a DAX formula?<BR />Thank you so much for your support!</P> Thu, 20 Oct 2022 08:34:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-many-days-left-till-the-used-value-will-reach-the-target/m-p/2853091#M91552 BenNguyen 2022-10-20T08:34:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-many-days-left-till-the-used-value-will-reach-the-target/m-p/2854567#M91682 <P>Here's some example of how to do such things... File attached. Just scrutinize the file thoroughly and you'll know everything.</P> Thu, 20 Oct 2022 23:15:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-many-days-left-till-the-used-value-will-reach-the-target/m-p/2854567#M91682 daXtreme 2022-10-20T23:15:20Z