Forum Discussion

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 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
6 years ago
Hi Falsufyani2020 ,

Check the file again: Download PBIX

7 Replies

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
camargos88
Community Champion
6 years ago
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
  Regular Visitor
  6 years ago
  Thanks Camargos88
  
  I should've told you that I'm new to Power Bi. would you please give me step by step?
  
  Thanks
  - camargos88
    Community Champion
    6 years ago
    Hi Falsufyani2020 ,
    
    Check this:
    
    Did I answer your question? Mark my post as a solution!
    Ricardo

Related content