Forum Discussion
Remove rows with single values in another column
Hi everyone,
I have a dataset of the following type.
ID Attribute Value
1.1 A red
1.2 A red
1.2 B red
1.3 A red
1.4 A red
1.5 B red
1.6 C red
1.7 C red
1.7 D red
I want to remove rows that are not repeated, and want to keep only those that have been repeated
I tried various filters but it didn't work.
What dax query would help filter the repeated ones out?
Thankss
- Anonymous3 years ago
Hi Anonymous ,
If you can work in Power Query, you can choose to Keep duplicates rows:
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
If you can work in Power Query, you can choose to Keep duplicates rows: