Finding Unique Rows

[Anonymous]

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.

1. Merging the columns Project, Role and Resource
2. Removing the dupicates from the new merged column
3. 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.

[selimovd · Accepted solution]

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 regards

Denis

Blog: WhatTheFact.bi