Forum Discussion
Multi-conditional find replace in Data Power Query from two seperate columns
Hi, I have an issue with some of the data being miss classified in my report. I am trying to find a solution on the Power Bi side instead of changing it in the data base. In Power Query does anyo...
Thanks for your help on this. lbendlin
My report is acting and refreshing so slow now with just a few changes. Is there any way to cut down on the refresh / load time of these new items? I only have 2 million rows too...
lbendlin
Super User
Super UserYou can instead opt to add a calculated column in DAX. That will be faster as it happens in memory.
The replacer function is likely not the source of your slowness as it only works on row level. You probably have other expensive transforms like sorting or merging. Those should be avoided.