Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to get the difference in time of two rows between out and in and then sum the differences for each category
For example: I have the following columns- ECN_ID, Date, Time, In/Out
I want to create another column called time difference that gives the difference between the rows
The time difference between:
out and in for ECN = 2 and date 5/10/24 is 10 mins, then 1 hour respectively so total = 01:10:00
for ECN=3 and date 5/10/24, first difference is of 5 mins, then 20 mins and then 25 mins so total becomes 00:50:00,
and for ECN=3 and date 6/10/24, first difference is of 5 mins, then 20 mins, then 25 and then 30 mins so total becomes 01:00:00
How to achieve this? Thanks in advance!
Solved! Go to Solution.
you can create a column
Proud to be a Super User!
you can create a column
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |