Daniel wu on 12 Jul 2015 01:13:50
is it possible to add support for "duration" data type in the report view as in Power Query?
- Comments (209)
RE: field of "duration" type
Hello is anybody listening. How many posts and other wasted resources are taken up by this failing?
RE: field of "duration" type
Still an ongoing issue. This is possible in Excel but not in Power BI. Seems to be a giant gap in capabilities between the two. When you change time to duration in query view, it errors out. And duration is not an available format type in report view for measures. When trying work arounds, using the format function to change a number to duration turns the value into text, which cannot be aggregated. Will this ever be fixed? Should be a simple patch.
RE: field of "duration" type
2024, and yet no duration format in dax that allow aggregation, especially on visuals.
So simple. Im gonna be fired soon cause i can't provide what needed . And all work arounds aren't good enough.. Thanks Microsoft....
RE: field of "duration" type
I got this same question in 2023 and I'm disappointed considering that's already asked in 2015...
What are you doing?
What are you waiting for?
RE: field of "duration" type
This is critical requirement in so many use cases, I can not believe we don't have a solution for this. In QlikSense/QlikView this functionality has been around for 10+ years. Any type of productivity reporting or contact center, turnaround time reporting would use this. Our end users do not want to see decimal representing portion of a day, or seconds in the y axis. h:nn:ss please. Any updates Microsoft??
RE: field of "duration" type
When will this feature (really basic feature) be improved?
RE: field of "duration" type
Is there a simple workaround to summarize duration, for example to get an average duration to use as an axis in a graph ?
RE: field of "duration" type
Please consider implementing this requirement, as this is widely required for many reports.
RE: field of "duration" type
Please consider implementing this into Power BI - it's obviously really needed out there. Time calculations are very common across businesses worldwide.