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:
Go to Solution.
Please check the below picture and the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
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 !
Hello @Niels_IRD !
You can remove duplicates based on 2 columns.
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!