Forum Discussion

Falsufyani2020

Regular Visitor

6 years ago

Solved

Remove Duplicates in Col A & group them by date

Hello I have excel sheet with the users logged in to a certain system on daily basis. each day the user might login to the system more than one time. I want to remove the duplicated user from eac...

Need Help

camargos88
6 years ago
Hi Falsufyani2020 ,

Check the file again: Download PBIX

ziying35

Impactful Individual

6 years ago

Can you simulate a result table and upload a file?

Falsufyani2020
Regular Visitor
6 years ago
Hello

the output I'm expecting after removing the duplicated users and group by date is:
Date Count of Unique Users per day
5/7/2020 20
5/6/2020 11
5/5/2020 17
Falsufyani2020
Regular Visitor
6 years ago
Sample tablehttps://1drv.ms/u/s!AkPc4pTA_tjDiLs8zacPy6FJZNjvBQ?e=fjSHKW
- camargos88
  Community Champion
  6 years ago
  Hi Falsufyani2020 ,
  
  Check the file again: Download PBIX

Forum Discussion

Remove Duplicates in Col A & group them by date

Related content

remove duplicate value within a row

Removing Duplicates

Fabric & Azure Data User Group Program Requirements & Benefits

Removing duplicates

Remove duplicates bug

Date	Count of Unique Users per day
5/7/2020	20
5/6/2020	11
5/5/2020	17