Forum Discussion

cumoczar's avatar
cumoczar
Microsoft Employee
6 years ago
Solved

Displaying time in a Table

I have a column that is a duration in a time format, yet when I add to a table it shows as a decimal.  For example, when looking in the query, the following value:   0.03:23:02.4000000   Is ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi cumoczar ,

     

    Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.

    If you only want to show duration of time in a Table report, I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi cumoczar ,

 

Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.

If you only want to show duration of time in a Table report, I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.

 

cumoczar's avatar
cumoczar
Microsoft Employee
6 years ago

Hi v-eachen-msft  - thanks for the suggestion, that did the trick!

 

-Curt