How to remove duplicates for each datetime in Power Query

[Niels_IRD]

In the image below you see my table which contains duplicate values for each hour and each day. 

I would like to remove the duplicates for each datetime.

another example below:

01/01/2022 1:00:00	Y
01/01/2022 1:00:00	Y
01/01/2022 1:00:00	Z
01/01/2022 2:00:00	X
01/01/2022 2:00:00	X
01/01/2022 2:00:00	Y

Expected output:

01/01/2022 1:00:00	Y
01/01/2022 1:00:00	Z
01/01/2022 2:00:00	X
01/01/2022 2:00:00	Y

[serpiva64]

Hi,

first insert a merge column

then remove duplicates in your merged column

then remove merged column

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[JorgePinho]

Hello @Niels_IRD !

You can remove duplicates based on 2 columns.

 

[JorgePinho]

Hello @Niels_IRD !

You can remove duplicates based on 2 columns.

 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.