Forum Discussion

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

Delete duplicate rows based on time (minute or hour)

Hello,   I have an issue and i cant resolv it after many research. Here my situation :  I want to delete duplicate data base on time , in the same hour for example for the ID "5267" i want ...
rfigtree's avatar
rfigtree
Icon for Resolver III rankResolver III
5 years ago

simplest thing to do is via power query. round date/time to level you need then remove duplicates. 

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

rfigtree Im in direct query , i think the best way its a dax formula , or if someone one tips without formula i'll take it.

Thank you