field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
Need duration that includes: days h:mm:ss and some folks also need the ms on the end. Most of my durations exceed 24 hours, so days is a critical component.
This should be standard - please consider immediately for next release at end of Feb!
Lou Apra commented
UP. It's 2020 now. New decade. Please don't wait for 10 year anniversary :)
Mark Wallström commented
Seems like a easy fix, what do I know. I do know however that I expected this to be a standard thing.
That would be great to have available this feature in Power BI.
I've seen many requests about this subject.
As far as I know, that request is so far suggested and until now i't's not been applied, I think that maybe can be a technical issue.
Kim M commented
Agreed! It is a lovely duration in Power Query, so why can't it also appear in Power Pivot?! Need duration that includes: days h:mm:ss and some folks also need the ms on the end. Most of my durations exceed 24 hours, so days is a critical component.
Dan Day commented
More than 4 years on and still not implemented
Zsofia Burkus commented
Mark Williams commented
I vote a big yes please to this one :)
Bret Pothier commented
I vote yes please. This would be a very handy addition.
Please add ASAP.
This is a massive missing element in Power BI.
Please bring up Excel's [h]:mm:ss format in Power BI ASAP! It's a pity to miss this feature in such a great tool.
Indeed; it's kind of weird that this is not supported right now? Please add! :)
Ricardo Torrent commented
Flynn Williford commented
Perhaps an easy way to implement this would be to have a duration format for the decimal number data type. The format could assume the decimal number represents a number of seconds and then format accordingly in views while leaving calculation models the same.
This is a feature that is most needed. Have a report where I need to add seconds and minutes. I was able to use the below conversion, but I am having problems adding the values by month. // Duration formatting
// * @konstatinos 1/25/2016
// * Given a number of seconds, returns a format of "hh:mm:ss"
d. nowak commented
This is a much needed feature that will further improve the versatility of this software. Please consider