Remove Duplicates in Col A & group them by date

[Falsufyani2020]

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 each day and group the result by date. my goal is counting unique users logged in to the system per day. below is a sample of the table.

Thanks

[camargos88]

Hi @Falsufyani2020 ,

I've created this file as example: Download PBIX 

There are 2 examples, with distinct on date column and another with custom column and first date (or the index if want).

Did I answer your question? Mark my post as a solution!
Ricardo

[Falsufyani2020]

Thanks Camargos88

I should've told you that I'm new to Power Bi. would you please give me step by step?

Thanks

[camargos88]

Hi @Falsufyani2020 ,

Check this:

Did I answer your question? Mark my post as a solution!
Ricardo

[ziying35]

Can you simulate a result table and upload a file? 

[Falsufyani2020]

Sample tablehttps://1drv.ms/u/s!AkPc4pTA_tjDiLs8zacPy6FJZNjvBQ?e=fjSHKW 

[camargos88 · Accepted solution]

Hi @Falsufyani2020 ,

Check the file again: Download PBIX 

[Falsufyani2020]

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