Forum Discussion

MH3's avatar
MH3
Helper V
6 years ago
Solved

Time Difference

Hello Everyone.   I have two columns Start Time  and End Time and want to calculate difference between two date/time columns but I can only get the column name by using an Aggregation function like...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    MH3 

    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.