Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a doubt about the next question. Which is better in terms of performance, Custom Column using PQuery or New Column using DAX?
Thanks to all for you answer.
Solved! Go to Solution.
Yeah, I would say that in your case you should definitely consider moving that to Power Query. General rule is that the further upstream that you can push the calculations, the better the performance downstream.
Well, overall, Power Query is only going to execute the calculation once per a query refreshing, so you will take a small performance hit during query refresh but after that you have a static value. With DAX, the calculation will essentially be done every time it is needed so you will have a performance hit each time.
Ok, thanks so much for your fast answer.
I have a model and i need to split some string values from various columns to use later like slicers. The fact table in the model have more than a million of rows and i'm thinking in transform my new DAX columns in Power Query columns to reduce the performance impact when the user use it.
Do you think i should do it?
Thanks again.
Yeah, I would say that in your case you should definitely consider moving that to Power Query. General rule is that the further upstream that you can push the calculations, the better the performance downstream.
Yes, I thinked the same.
If somebody need it, here you have a link that explain so well my first question:
http://radacad.com/m-or-dax-that-is-the-question
Thanks Greg_Deckler
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |