Forum Discussion
How to remove duplicates for each datetime in Power Query
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 |
Hi,
Please check the below picture and the attached pbix file.
4 Replies
Hello Anonymous !
You can remove duplicates based on 2 columns.
Hi,
Please check the below picture and the attached pbix file.
Hello Anonymous !
You can remove duplicates based on 2 columns.
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 !
