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.

 

In this example, I want to delete duplicates (code 2111) in the period 01/8/2019 and in the period 01/09/2019.

So, I need this information only twice. One time for the period 01/08/2019 and 1 time for the period for the period 01/09/2019.

I need this help to make a history for my company.

 

Can someone help me with the M language ?

 

thanks

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

4 Replies

  • 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