https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-help/m-p/2073725#M46959 <P>I want to find the following.&nbsp;&nbsp;How many qty is having end date later than start date (% behind the end date) – Quickly point out which qty is behind with deliveries. How to achieve this via DAX and how to show this as a bar graph</P><P>&nbsp;</P><P>&nbsp;data format is as below</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Start date</TD><TD>End Date</TD><TD>&nbsp;</TD><TD>Ordered QUANTITY</TD><TD>Reserved Qty</TD></TR><TR><TD>01/03/2021</TD><TD>16/08/2021</TD><TD>&nbsp;</TD><TD>2000</TD><TD>2000</TD></TR><TR><TD>01/03/2021</TD><TD>16/08/2021</TD><TD>&nbsp;</TD><TD>4000</TD><TD>3000</TD></TR><TR><TD>02/03/2021</TD><TD>01/11/2021</TD><TD>&nbsp;</TD><TD>24000</TD><TD>24000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>9000</TD><TD>5000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>15000</TD><TD>15000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>18000</TD><TD>18000</TD></TR><TR><TD>05/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>27000</TD><TD>26000</TD></TR></TBODY></TABLE> Mon, 13 Sep 2021 21:47:46 GMT Anonymous 2021-09-13T21:47:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-help/m-p/2073725#M46959 <P>I want to find the following.&nbsp;&nbsp;How many qty is having end date later than start date (% behind the end date) – Quickly point out which qty is behind with deliveries. How to achieve this via DAX and how to show this as a bar graph</P><P>&nbsp;</P><P>&nbsp;data format is as below</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Start date</TD><TD>End Date</TD><TD>&nbsp;</TD><TD>Ordered QUANTITY</TD><TD>Reserved Qty</TD></TR><TR><TD>01/03/2021</TD><TD>16/08/2021</TD><TD>&nbsp;</TD><TD>2000</TD><TD>2000</TD></TR><TR><TD>01/03/2021</TD><TD>16/08/2021</TD><TD>&nbsp;</TD><TD>4000</TD><TD>3000</TD></TR><TR><TD>02/03/2021</TD><TD>01/11/2021</TD><TD>&nbsp;</TD><TD>24000</TD><TD>24000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>9000</TD><TD>5000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>15000</TD><TD>15000</TD></TR><TR><TD>01/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>18000</TD><TD>18000</TD></TR><TR><TD>05/03/2021</TD><TD>03/04/2023</TD><TD>&nbsp;</TD><TD>27000</TD><TD>26000</TD></TR></TBODY></TABLE> Mon, 13 Sep 2021 21:47:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-help/m-p/2073725#M46959 Anonymous 2021-09-13T21:47:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-help/m-p/2076435#M47041 <P>I'm afraid all the end dates are later than their corresponding start dates.</P> Tue, 14 Sep 2021 23:19:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-help/m-p/2076435#M47041 daxer-almighty 2021-09-14T23:19:11Z