Forum Discussion
Conditional Table.ReplaceValue (if to define it replace will be applied or not)
Hi I have query with 3 columns: InvoiceNumber, InvoiceType and InvoiceAmount. There are 40K+ records, and half a dozen of them have the wrong InvoiceType (need to change com "Service" to "Product...
Is this query a custom function or others? Which error occurs when you implement it?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
It's the standard replace value function from power query. The point is that I cannot make it work with if statements inside it.