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.
HI @Anonymous,
There are lots of difference between m query and dax query, for example:
M query contain row index, so you can direct refer specific rows. (data model not has row index and column index)
M query support list, records, table type value which dax not support.
M query can invoke custom functions and other cached steps.
In my opinion, the key point of difference is M query is familiar with transform data, but is hard to calculate with complex conditions. (low performance)
Dax query is good as calculate with specific filters and conditions, it also has lots of functions to help calculation, but it impossible to transform data.
Reference:
What's the difference between DAX and Power Query (or M)?
Regards,
Xiaoxin Sheng
HI @Anonymous,
There are lots of difference between m query and dax query, for example:
M query contain row index, so you can direct refer specific rows. (data model not has row index and column index)
M query support list, records, table type value which dax not support.
M query can invoke custom functions and other cached steps.
In my opinion, the key point of difference is M query is familiar with transform data, but is hard to calculate with complex conditions. (low performance)
Dax query is good as calculate with specific filters and conditions, it also has lots of functions to help calculation, but it impossible to transform data.
Reference:
What's the difference between DAX and Power Query (or M)?
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |