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
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
