Forum Discussion
rogletree
Helper III
5 years agoTransform data in power query vs. dax
Not really sure if the title accurately describes what I'm asking about, but basically I'm just wondering what the pros/cons are to transforming data in power query vs doing it with DAX. I prefer po...
rogletree
Helper III
5 years agoamitchandak thanks for the reply. What exactly do you mean when you say that DAX can be slower than M? Writing the code itself is slower? Or the time it takes Power BI to do the calculations is slower?
v-kelly-msft
Community Support
5 years agoHi rogletree ,
As for "Slow",all depends.
Check below blog for the differences between dax and power query:
https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!