https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2749466#M84789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp; Thank you that worked perfectly <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 06 Sep 2022 07:16:35 GMT georgec96 2022-09-06T07:16:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2739108#M84106 <P>Hi All,</P><P>&nbsp;</P><P>I've got the following dataset&nbsp;</P><P><img /></P><P>&nbsp;</P><P>I'm trying to figure out a way of getting a list of order numbers where the last actcod (based on trndte) was 'CANPCK'.</P><P>&nbsp;</P><P>Any help would be much appreciated.</P><P>&nbsp;</P><P>Thank you</P> Wed, 31 Aug 2022 21:02:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2739108#M84106 georgec96 2022-08-31T21:02:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2739322#M84123 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="357242" data-lia-user-login="georgec96" class="lia-mention lia-mention-user">georgec96</a> , refer if my blog can help</P> <P><A href="https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0" target="_blank">https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0</A></P> <P><A href="https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e" target="_blank">https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e</A></P> Thu, 01 Sep 2022 01:44:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2739322#M84123 amitchandak 2022-09-01T01:44:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2749466#M84789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp; Thank you that worked perfectly <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 06 Sep 2022 07:16:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-transaction-per-order/m-p/2749466#M84789 georgec96 2022-09-06T07:16:35Z