Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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
?
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.
User | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |