Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
An operation that could be done both with PowerQuery M and with DAX
Is it better to do it with PowerQuery M or No difference?
Solved! Go to Solution.
Hi @tlotfi
Power query is better for model data (clean, transform etc.) but DAX is better for calculations (specially for measures which don't take a lot of ram when you’re doing massive computations).
Good thread to go through.
https://community.powerbi.com/t5/Desktop/Dax-or-M-Language/td-p/136827
I would say that if it can be done in PowerQuery, that's where you should do it so that you don't slow down PowerBI after the data is loaded. For example, if you're creating another column, it's best to do that in PowerQuery as once it's done, it's done. If you do a calculated column in DAX, then everytime you apply a filter, cross-filter, or whatever, the calculated column get re-calculated.
I would say that if it can be done in PowerQuery, that's where you should do it so that you don't slow down PowerBI after the data is loaded. For example, if you're creating another column, it's best to do that in PowerQuery as once it's done, it's done. If you do a calculated column in DAX, then everytime you apply a filter, cross-filter, or whatever, the calculated column get re-calculated.
Hi @tlotfi
Power query is better for model data (clean, transform etc.) but DAX is better for calculations (specially for measures which don't take a lot of ram when you’re doing massive computations).
Good thread to go through.
https://community.powerbi.com/t5/Desktop/Dax-or-M-Language/td-p/136827
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |