topic Re: Duration in Desktop

Duration

Anonymous — Wed, 09 Mar 2022 14:19:27 GMT

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.

Re: Duration

amitchandak — Wed, 09 Mar 2022 14:26:56 GMT

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

But this column should work

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

Re: Duration

Anonymous — Wed, 09 Mar 2022 14:40:53 GMT

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)