Power Query M vs. Power BI DAX Calculated Column

[nimblecat]

Hello, I want to compare the performance (loading time, memory, CPU cores etc.) between Power Query M vs. DAX calculated column. Is there an easy way to see the performance of running one or the other? Maybe an add-in or something I can use to compare the two? If not, any thoughts on general best practices would be greatly appreciated!!!

Thanks!

[ppm1]

Please see this article.

Comparing DAX calculated columns with Power Query computed columns - SQLBI

Pat

[talbot]

My understanding is limited, but I believe Dax calculated columns are preferable to Power Query M merge statements, but otherwise, Power Query M is preferable to Dax.