delete duplicate item codes M language

[Anonymous]

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

[AnkitBI]

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]

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 · Accepted solution]

Try selecting all the Columns and then click on Remove duplicates

[Anonymous]

@AnkitBI 

i do it ! Thanks for ur help !