Forum Discussion
Identifying duplicates in one column
83dons ,
No worries! If you’re not comfortable with DAX, you can do this easily in Power Query as well—no formulas needed.
Here’s how:
- In Power Query, select the NNumber column.
- Go to the “Group By” option in the toolbar.
- Group by NNumber, and add an “All Rows” operation (or count if you want to see how many duplicates).
- Filter the grouped table to keep only NNumbers with a count > 1.
- Expand to show the original StaffID and NNumber columns.
Step-by-step:
- Home > Transform Data (opens Power Query)
- Select NNumber column > Home tab > Group By
- Group by NNumber, use “Count Rows” as the new column
- Filter the Count column for values greater than 1
- Expand the new column to get your StaffID/NNumber pairs
This will give you exactly the output you need—no DAX required!
translation and formatting supported by AI
Hi 83dons,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are trying to way to list all the duplicate values in a column. As burakkaragoz and johnt75 have already responded to your query, please go through their response and check if it solves your issue.
I would also take a moment to thank burakkaragoz and johnt75, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.