https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-last-date-value-of-measure/m-p/2884496#M93472 <P><SPAN>I have a table with shipment number ,dates and a measure "Backlog". Need to calculate the Total backlog of that shipment and consider the latest date value.</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>Shipment</TD><TD>Measure(backlog)</TD><TD>Required Backlog (last date value)</TD></TR><TR><TD>30/10/2022</TD><TD>AX</TD><TD>720</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>AX</TD><TD>0</TD><TD>0</TD></TR><TR><TD>30/10/2022</TD><TD>BX</TD><TD>840</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>BX</TD><TD>0</TD><TD>0</TD></TR><TR><TD>30/10/2022</TD><TD>CX</TD><TD>35</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>CX</TD><TD>12</TD><TD>12</TD></TR></TBODY></TABLE> Fri, 04 Nov 2022 05:13:19 GMT insandur 2022-11-04T05:13:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-last-date-value-of-measure/m-p/2884496#M93472 <P><SPAN>I have a table with shipment number ,dates and a measure "Backlog". Need to calculate the Total backlog of that shipment and consider the latest date value.</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>Shipment</TD><TD>Measure(backlog)</TD><TD>Required Backlog (last date value)</TD></TR><TR><TD>30/10/2022</TD><TD>AX</TD><TD>720</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>AX</TD><TD>0</TD><TD>0</TD></TR><TR><TD>30/10/2022</TD><TD>BX</TD><TD>840</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>BX</TD><TD>0</TD><TD>0</TD></TR><TR><TD>30/10/2022</TD><TD>CX</TD><TD>35</TD><TD>0</TD></TR><TR><TD>31/10/2022</TD><TD>CX</TD><TD>12</TD><TD>12</TD></TR></TBODY></TABLE> Fri, 04 Nov 2022 05:13:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-last-date-value-of-measure/m-p/2884496#M93472 insandur 2022-11-04T05:13:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-last-date-value-of-measure/m-p/2884523#M93473 <P>Hi,</P> <P>Please check the below picture and the attached pbix file.</P> <P>It is for creating a new column</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">Required backlog CC = VAR _latestdate = MAXX ( FILTER ( Data, Data[Shipment] = EARLIER ( Data[Shipment] ) ), Data[Date] ) VAR _backlog = MAXX ( FILTER ( Data, Data[Shipment] = EARLIER ( Data[Shipment] ) &amp;&amp; Data[Date] = _latestdate ), Data[Measure(backlog)] ) RETURN IF ( Data[Measure(backlog)] = _backlog, _backlog, 0 ) </LI-CODE> <P>&nbsp;</P> Fri, 04 Nov 2022 05:31:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-last-date-value-of-measure/m-p/2884523#M93473 Jihwan_Kim 2022-11-04T05:31:14Z