Remove duplicate counts

[ThomasWeppler]

Hi Power Bi community

I need to find a way to remove checkins that has been made by mistake. This would be checkins where made by the same person, the same day on the same task. So I table would look like this

Table

[Checkin]

Columns

Index = an index colum

Checkin_id = the id for the checkin which are all individual

User_id = an id for each user

Task_id = an id for each task

Date= the date the checkin happpend

I want to count the number of checkin_ids, but exlude all rows where users, tasks and dates are duplicates.

Can anyone help me? It would be greatly appriciated.

[zenisekd · Accepted solution]

Hi  @ThomasWeppler , there are several options the simple one is in Power Query.  In Power Query select multiple columns, based on which you want to remove the duplicates and use "Remove Duplicates"

[ThomasWeppler]

Thanks a lot. That solved the problem.