Last version purchase order

Question

Hello everyone,I get all datas from a table who contains the purchase order. But there are many version for each order.And I would like only the last version of each order.&nbsp;Exemple :Table Purchase_LineN°&nbsp; &nbsp; &nbsp; &nbsp;Line_N°&nbsp; &nbsp; &nbsp; Version_N°&nbsp; &nbsp; &nbsp; ItemCF01&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;item01 =&gt; OLDCF01&nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;item02 =&gt; OLDCF01&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;item02 =&gt; I want itCF02&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;item03 =&gt; I want it&nbsp;Today, I get 4 lines but I would like to get only 2 lines (CF01 line1 version2 and CF02 line1 version1)&nbsp;Is it possible for me to get only the lines I want?&nbsp;Thank you for all your help

anonymous · Accepted Answer

Anonymous,You can create the following columns in your table, and drag the checkcol field to visual level filter of your visual, then set its value to 1.
lastversion = CALCULATE(max(Purchase_Line[Version_N°]),ALLEXCEPT(Purchase_Line,Purchase_Line[N°]))
checkcol = IF(Purchase_Line[Version_N°]=Purchase_Line[lastversion],1,0)
Regards,Lydia

Forum Discussion

Last version purchase order

2 Replies

Related content

Version control

Microsoft fabric license purchase

V-Order & Z-Order

dax expression not working - Purchase Order Value

Is it possible to create a report that builds a purchase order