Forum Discussion
Duration conversion issues
Hi All, I faced a problem while generating a report and thought you can help. I have a report that includes 8 tables. The query is pulled from microsoft sql server. I have a column called Time e...
In DAX, just take the 2.01947111 and do this:
Elapsed=VAR dur= SUM(Table[Time Elapsed])VAR d=INT(dur)*24 VAR h=HOUR(dur)VAR m=MINUTE(dur) VAR s=SECOND(dur) VAR totalh = d+h VAR Result = totalh&":"&m&":"&s RETURN
Result
--Nate