Confused with duration support

[pmdci]

Hi,

I am a little confused about the support for duration in Power BI.

I can see that there is an option to configure a column in the Query Editor as Duration under Date & Time Column, however the option to set is as duration is grayed out. I tried with fields formatted as HH:MM:SS format and decimals, but no luck.

Also what if I am hoping that such formatting for duration would be done at the tabular model, not at the query time. Say that I want to create a PowerPivot model in Excel 2016... How would I go about setting a field as duration?

Thank you for your time and support.

Regards,

P

[Greg_Deckler · Accepted solution]

@pmdci - Duration is formatted d.hh:mm:ss and you first have to make sure that the Data Type in the Transform | Any Column area is set to "Duration", then the button that you are referring to will not be grayed out.

[Anonymous]

Thank you so much for this post!  I've been searching everywhere for the correct format to make duration work.

[greggyb]

There is no support for a duration type in DAX/Tabular yet. I do not know if this is planned, but Power BI has brought more alignment between M and Tabular data types so far.

If you import a duration type into a data model, it will be cast to a decimal type.