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.

MH3's avatar
MH3
Helper V
6 years ago

Dear Sir Anonymous amitchandak  Greg_Deckler 

 

I have used this Formula

Time DF = SUM('Log Header'[EndTime])-SUM('Log Header'[StartTime])

 

and my Table Structure is this:


when I used the formula in the viusalization it shows me bigger values
Filter is for HOTEL DAVOS, and the Table isSorted for Hotel Davos as Well

, is it correct or worng I can't verify it please help!

amitchandak's avatar
amitchandak
Super User
6 years ago

MH3 , Try like

Time DF = sumx('Log Header',('Log Header'[EndTime])-('Log Header'[StartTime])