Forum Discussion
Finding Unique Rows
I have a table with 5 columns fo data. I need to find all the unique rows based on three of the columns. For example, if my table looks like this:
Source---Project---Role---Resource---Type
1---------AB--------Help--Tony--------PLN
1---------AB--------Help--Sarah-------PLN
1---------AB--------Help--Tony--------PLN
I want to get back this:
Source---Project---Role---Resource---Type
1---------AB--------Help--Tony--------PLN
1---------AB--------Help--Sarah-------PLN
Right now, I'm doing the following.
- Merging the columns Project, Role and Resource
- Removing the dupicates from the new merged column
- Deleting the merged column
Is there a better way to do this? Doing it this way (with the merged column) takes a long time for the query to run.
Hey Anonymous ,
yes, there are definitely better ways.
I guess you are doing this preparation in Power Query, right?
In this case you have to first mark all the columns.
And then you go to "Remove Rows" --> "Remove Duplicates".
Afterwards you have unique rows only.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
1 Reply
Hey Anonymous ,
yes, there are definitely better ways.
I guess you are doing this preparation in Power Query, right?
In this case you have to first mark all the columns.
And then you go to "Remove Rows" --> "Remove Duplicates".
Afterwards you have unique rows only.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi