show only latest sequence
1 TopicOnly Display Latest Sequence
Goodday - I am looking for the DAX code/formula I can use to do the following. I have a list of Open PO numbers. Each open PO can have up to 9 different confirmation types. Each confirmation type results in a seperate line and I only want to show the PO line with the latest confirmation. The different confirmations are below in sequence: blank or null = not confirmed yet AB P2 E1 E2 E3 E4 E5 SN Example of my data: PO Ord Qty Confirmation Type Confirmation Seq Confirmation Date 450123 10 AB 2 6/22/24 450123 10 P2 3 7/10/24 450123 10 E1 4 9/5/24 450123 10 E2 5 10/31/24 450123 10 E3 6 11/2/24 450123 10 E4 7 11/30/24 450123 10 E5 8 12/1/24 450123 10 SN 9 12/25/25 450123 10 1Solved1.5KViews0likes7Comments
