topic Question - Optimization - is there benefits to doing data cleaning in the Power Editor vs Dax? in DAX Commands and Tips

Question - Optimization - is there benefits to doing data cleaning in the Power Editor vs Dax?

Awollet33 — Tue, 13 Apr 2021 12:34:54 GMT

Re: Question - Optimization - is there benefits to doing data cleaning in the Power Editor vs Dax?

amitchandak — Tue, 13 Apr 2021 13:43:38 GMT

Awollet33 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Also check:

https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/

https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper

https://sqldusty.com/2015/08/10/cleaning-your-powerbi-power-query-code/
Appreciate your Kudos.

Re: Question - Optimization - is there benefits to doing data cleaning in the Power Editor vs Dax?

Anonymous — Tue, 13 Apr 2021 14:14:17 GMT

Awollet33

Of course. If there weren't, why would Microsoft bother creating and investing into two different technologies? DAX is a Data Analysis eXpression language and its goal is to facilitate data analysis. Power Query has a functional language, called M, which is a data mashup language. There are many, many benefits to data preparation in PQ but some of them are: 1) one can easily use recursion in M (not possible in DAX), 2) standard operations like pivoting, data imputation, string manipulation, statistical functions, using ML algorithms are one-click (or almost one-click) operations in PQ, 3) columns calculated in PQ are much, much, much better compressed than columns calculated in DAX (which are not compressed at all). There are many more benefits but the above come to my head right away.