Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
41 | |
32 | |
23 | |
23 | |
22 |