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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi all,
I had a question about a formula I wanted to create. I created a calculated column that shows the average time a object was at a certain point (TimeAtPoint) what I want to know is the time between two of those records. For example:
Through slicing I want to know what the time is between for example A and B which would give 00:10:00 in this example. Between A and C it would give 00:30:00 (this variable would be called TravelTime)
(TimeAtPoint is in H:mm:ss)
the next step is to calculate the distance between those 2 points, which could be achieved by TravelTime * speed. Although I have no idea how to achieve this yet.
Thanks in Advance !
Solved! Go to Solution.
Perhaps use a measure that calculates the difference between the MIN and MAX of the column?
@Anonymous,
Through slicing I want to know what the time is between for example A and B which would give 00:10:00 in this example.
So you will select two items in your slicer? If that is the case, you can use the measure below.
Difference = MAX(Table1[TimePoint])-MIN(Table1[TimePoint])
Regards,
Charlie Liao
@Anonymous,
Through slicing I want to know what the time is between for example A and B which would give 00:10:00 in this example.
So you will select two items in your slicer? If that is the case, you can use the measure below.
Difference = MAX(Table1[TimePoint])-MIN(Table1[TimePoint])
Regards,
Charlie Liao
Hi all,
First of all thanks for taking time to help me.
And yes this worked the same for me as in the example @v-caliao-msft recreated. The next step in my formula would be to calculate a distance by "TimeDifference" * "speed". Although I am not sure how to approach this problem since I don't know how to make the multiply understand that I want "TimeDifference" multiplied by the speed the object had between point A and B or A and C for example. I was wondering if any of you had an idea on how to approach this problem.
Regards,
L. Meijdam
Perhaps use a measure that calculates the difference between the MIN and MAX of the column?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.