Last version purchase order

[Anonymous]

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.

Exemple :

Table Purchase_Line

N°       Line_N°      Version_N°      Item

CF01    1                1                     item01 => OLD

CF01    2                1                     item02 => OLD

CF01    1                2                     item02 => I want it

CF02    1                1                     item03 => I want it

Today, I get 4 lines but I would like to get only 2 lines (CF01 line1 version2 and CF02 line1 version1)

Is it possible for me to get only the lines I want?

Thank you for all your help

[Anonymous · Accepted solution]

@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

[Anonymous]

Thank you!!

It sounds good!!