Forum Discussion
Anonymous
5 years agoNot applicable
Complex Row Time Difference
Hi Team. Is there a way to reproduce this in Powerbi.? This is the table I have to, in theory, I would like to subtract the time or duration between 2:36 PM and 2:50PM the same way I did in...
Ashish_Mathur
5 years agoSuper User
Hi,
Try this calculated column formula
=data[start time]-calculate(max(data[end time]),filter(data,data[start time]<earlier(data[start time])))
Hope this helps.