Forum Discussion
Power Query M vs. Power BI DAX Calculated Column
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!
2 Replies
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.
Please see this article.
Comparing DAX calculated columns with Power Query computed columns - SQLBI
Pat
