What's the practical difference between doing a calculated column in M and doing one in DAX?

[Anonymous]

Any? Performance? Nothing?

thanks,

sff

[v-shex-msft · Accepted solution]

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