Forum Discussion
Solved
What is generally faster - Table.ReplaceValue or Table.TransformColumns, for multiple replacements?
Hi All! I’ve got a question - if I need to do several replacements in a table column - what is the fastest way to do that, by design (does NOT matter that one way allows to make more types of transof...
andreyminakov,
You can analyze the power query performance by using trace log. See https://www.excelando.co.il/en/analyzing-power-query-performance-source-large-files/.
Regards,
Lydia
andreyminakov,
It depends on your data. How would you replace the values in the column? To optimize multiple replacements. you can combine Table.ReplaceValue and Table.TransformColumns functions.
There is a similar thread for your reference:
https://community.powerbi.com/t5/Desktop/Optimizing-multiple-replacements/td-p/102389
Regards,
Lydia