Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Create a composite model and then add your own tables to the model if you can't change the source via Power Query.
@Anonymous Hello, can you be more specifric pls
simplest thing to do is via power query. round date/time to level you need then remove duplicates.
@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
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
19 | |
15 | |
7 | |
6 |