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!
@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
@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
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
