Forum Discussion
Grouping..
Hi there, I am trying to use the 'countdistinct' function within Bi - which seems to work in some capacity, but the totals don't add up which is why I've tried to head down the grouping route. Wh...
Anonymous
In Power Query, select both the Date and the User Column pressing CTRL, right-click, choose Remove Duplicates. You will get rid of any duplicates within Date and User and retain all other columns as well.
Anonymous
In Power Query, select both the Date and the User Column pressing CTRL, right-click, choose Remove Duplicates. You will get rid of any duplicates within Date and User and retain all other columns as well.
This works! Thank you so much!