Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an issue that I can't resolve after some research.
Here my situation :
I want to delete duplicate data based on time who have just few second diffrence like the "IdUtilisateur" : 7971, and i want to keep the one who have comment , so the seconde row (18/01/2021 13:25:45 with the comment "Probleme de calendrier livraison")
I don't know if my example is clear. If you have any question ask me.
Thank you for your future answer
Great Day
@ItSupportElm , One way if remove seconds from the date
New date = Date = date(year([datetime]),month([datetime]),day([datetime])) + Time(Hour([datetime]),Min([datetime]))
Other wise we need to create a flag based on the previous record, like 30 sec diff
new column =
var _max = maxx(filter(Table, [id] = earlier([id]) && [datetime] <earlier([datetime])),[datetime])
return
if( datediff( _max,[datetime],second) <=30,1,0)
remove 1
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |