topic Re: Delete duplicate rows based on time (minute or hour) in DAX Commands and Tips

Delete duplicate rows based on time (minute or hour)

ItSupportElm — Thu, 18 Feb 2021 09:17:48 GMT

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 to remove the row 03/02/2021 08:22:00 and keep the row two other row that on different date and time ( 5267 - 29/01/2021 07:50:28 and 5267 - 03/02/2021 08:21:57).

I dont know if my exemple is clear , if you question ask me.

Thank you for helping me.

Great Day

Re: Delete duplicate rows based on time (minute or hour)

rfigtree — Thu, 18 Feb 2021 10:01:09 GMT

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

Re: Delete duplicate rows based on time (minute or hour)

ItSupportElm — Thu, 18 Feb 2021 12:32:12 GMT

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

Re: Delete duplicate rows based on time (minute or hour)

Anonymous — Thu, 18 Feb 2021 15:53:35 GMT

Create a composite model and then add your own tables to the model if you can't change the source via Power Query.

Re: Delete duplicate rows based on time (minute or hour)

ItSupportElm — Fri, 19 Feb 2021 10:38:34 GMT

Anonymous Hello, can you be more specifric pls

Re: Delete duplicate rows based on time (minute or hour)

Anonymous — Fri, 19 Feb 2021 12:56:10 GMT

Sure: Use composite models in Power BI Desktop - Power BI | Microsoft Docs