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
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.
Yes, Power Query (M code) is executed as data is loaded into the model. DAX is essentially executed after the data is loaded into the model. They are definitely independent of one another.