Last transaction per order

[georgec96]

Hi All,

I've got the following dataset 

I'm trying to figure out a way of getting a list of order numbers where the last actcod (based on trndte) was 'CANPCK'.

Any help would be much appreciated.

Thank you

[georgec96]

@amitchandak  Thank you that worked perfectly 🙂

[amitchandak · Accepted solution]

@georgec96 , refer if my blog can help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...