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 Star...
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)

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)