Forum Discussion
Helper IIITransform data in power query vs. dax
Super Userrogletree , Duplication of the data in power query that gives me worry. Dax solution can be slower than M but it might overall give much more gain in some cases.
But I think you have to checkout with what you need.
Selectcolumns , calculatetable, summarize should help you out. Try to avoid crossjoin as far as possible.
This is good blog on joins -https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
rogletreeamitchandak 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
Hi 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,
KellyDid I answer your question? Mark my post as a solution!