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 is not supported in DirectQuery mode. Is there a way for me to do this conversion while still in DirectQuery mode? Thanks.
You might try using a DAX column instead. https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
7 Replies
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
