Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duration

Hi, 
First, when I imported my Excel data I had to set the Data Type as Time.
I was receiving an error when I wanted to set it as Duration. 
Current Duration Format: 13:30 (hh:nn)
I have the Start Time e.g 15:05 and End Time e.g. 16:10
I have tried DAX DATEDIFF but the return came back as 00:00

I am unable to create valid Visualisation for the Time Duration. 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You will not be able display duration on y axis

     

    But this column should work

     

    datediff([start time], [end time],second)

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You will not be able display duration on y axis

     

    But this column should work

     

    datediff([start time], [end time],second)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you amitchandak 

    Unfortunately, this formula doesn't work for me. The result is 00:00
    my formula:
    TimeDuration =     DATEDIFF('FACT TABLE'[Start Time],'FACT TABLE'[End Time], second)