Forum Discussion

Ley022's avatar
Ley022
Frequent Visitor
5 years ago

datediff for first dates

Hi, I want to calculate the time difference (datediff) in days between two dates: Timestamp and Date (blue). But I want to calculate this difference for the first date of date, for every IDs. If it ...
Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Ley022 , Logic is not very clear.

 

You can try like


new column =
var _min = minx(filter(table,[Id] =earlier([ID])),[Date])
return
if([Date]=_min , datediff([date], [timestamp], day), blank())