Forum Discussion
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
- zenisekdSuper User
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"
- ThomasWepplerImpactful Individual
Thanks a lot. That solved the problem.