Forum Discussion
Solved
Seconds to Duration in Direct Query
Hello all, I have a column with seconds. I created another column to convert it to duration. Whenever I create that column and do the conversion, it tells me that this step results in a query that i...
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?
