Forum Discussion
Solved
Duration in Query Section but not in
I have seen this solution, listed here, but want to know, when is there a duration type for a column in the Power Query Editor, but this does not translate to the Visualisatoon. WHen I am in p...
Hi Vexander,
AFAIK, power bi not support duration type, you can't use it in data model.
In my opinion, you can try to use duration function to transform them to total second or split to multiple columns with time unit.Duration.TotalDays Returns the total magnitude of days from a Duration value. Duration.TotalHours Returns the total magnitude of hours from a Duration value. Duration.TotalMinutes Returns the total magnitude of minutes from a Duration value. Duration.TotalSeconds Returns the total magnitude of seconds from a duration value. Regards,
Xiaoxin Sheng
Hi Vexander,
AFAIK, power bi not support duration type, you can't use it in data model.
In my opinion, you can try to use duration function to transform them to total second or split to multiple columns with time unit.
| Duration.TotalDays | Returns the total magnitude of days from a Duration value. |
| Duration.TotalHours | Returns the total magnitude of hours from a Duration value. |
| Duration.TotalMinutes | Returns the total magnitude of minutes from a Duration value. |
| Duration.TotalSeconds | Returns the total magnitude of seconds from a duration value. |
Regards,
Xiaoxin Sheng
Thank you Anonymous That is not quite what I would like to see, but I guess for not it will have to do for now, thank you.
I