Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
2 years ago
Solved

Remove duplicate counts

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.

 

 

  • 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"

     

     

2 Replies

  • 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"