Removing Duplicate rows with condition

[cj_sh]

I have a data for a billing system, it has a unique Invoice no..  Some time a invoice get revised or corrected, due to which system add -01, -02 series every time a invoice got revised or corrected. 

so in the data now I have previous invoice as well as new revised invoice. i.e.  IN-1321 and INV-1321-01.  

Here I need to consider only invoice that has INV-1321-01, and ignore the INV-1321.

also I case of if invoice again got revised then the new invoice no. will be INV-1321-02. and then I have to consider this only and ignoring other two invoice.

Not getting any hint how to achieve it.

[Anonymous · Accepted solution]

try somethink like

First split column by seperator

Then you have ID and next to it version.

New table=summerize(Table,table[ID],"MAX version",max(table[Version])

the again concatenate it to single column.

New col=isblank(NEw table[version]),table[ID],table[ID] & "-" &'New table'[MAX version]

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/91...