Forum Discussion
Time Difference
You can still create a measure with sum/max/min, and change the to Time format.
Measure = SUM('Table (2)'[End])-SUM('Table'[Start])If you cannot make the columns in a same table, you should have a relationship between the two tables.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can still create a measure with sum/max/min, and change the to Time format.
Measure = SUM('Table (2)'[End])-SUM('Table'[Start])
If you cannot make the columns in a same table, you should have a relationship between the two tables.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello! to calculate the time difference between two columns, you can use the DATEDIFF function, to calculate it in a new column, which in your case would be:
Columna_nueva = DATEDIFF(tabla[EndTime], tabla[StartTime], minute)
and you can change the unit of measurement you want to be returned, in this case "Minute".
What if, the format of this is as integer or decimal.
I do not know the method for this to be in time format, I hope it serves, Greetings!