Forum Discussion
Seconds to Duration in Direct Query
You might try using a DAX column instead. https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Did you create that column in Power Query M code or in DAX?
I made the column in power query M code
You might try using a DAX column instead. https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Okay, it is working perfectly. One other question. How would I go about getting the sum and average of the dax column. It has told me that it is a string but when i convert it to datetime it still tells me that sum is not supported in direct query. Any suggestions?
Ah yes, that is a downside. What about this update that I wrote a while ago:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639
?