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
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
?
It worked, thank you for all your help! Sorry to continue this thread but I have one last question. So I've already done some filtering in power query for that data set. I used that measure but found out that it takes into account all the data before the filtering done in power query. Are dax and power query independent of each other as in I would also need to filter out in dax the way I made filters in power query? Once again thanks for all your help.