Forum Discussion
Last version purchase order
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 P...
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,
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
Thank you!!
It sounds good!!