Forum Discussion

Falsufyani2020's avatar
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's avatar
camargos88
Icon for Community Champion rankCommunity 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's avatar
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's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Falsufyani2020 ,

     

    Check this:

     

     

     

     

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