Filtering on specific conditions

[Anonymous]

Hello everyone,

I have a table that looks as per below.

I would like to filter the table on the condition whereby if there are multiple rows of the same material, it will filter those with the 'X'. If there's isn't any multiple material, then it remains the same. This would need to be done in Power Query as I will need to merge it with other tables.

Thanks for your help and support!

[SpartaBI · Accepted solution]

@Anonymous is there a logic why it's the 2nd or you just one to remove one of them?
Also, why did you remove 3-00335-53? did you mean the one above?

Basically you can just use the remove duplicates on that column and it will only keep one of them. You can sort it before that step by another column for maybe the sorting logic you need and it will keep always the upper ones

      

Showcase Report – Contoso By SpartaBI