Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

delete duplicate item codes M language

Hello! First, I wish to apologize for my English. I am new to power bi and I would like some help on a M language I would like to delete duplicate item codes that are present in the same period. ...
General Comment
Need Help
Tips and Tricks
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    Try selecting all the Columns and then click on Remove duplicates

AnkitBI's avatar
AnkitBI
Solution Sage
6 years ago

What other columns you have and are they having same values. If yes, Then you can use Remove Duplicates. If not, then share complete Row details.

 

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your feedback AnkitBI 

    My other columns have the same value. When I use the delete duplicates button, it removes the code that included in the date 01/09/2019

    • AnkitBI's avatar
      AnkitBI
      Solution Sage
      6 years ago

      Try selecting all the Columns and then click on Remove duplicates

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        AnkitBI 

        i do it ! Thanks for ur help !