Forum Discussion

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
5 years ago
Solved

Table.ReplaceMatchingRows not working as expected

I have a requirement to replace multiple values of a multiple columns in a table, like    Order        Item             Qty          Serial 1 2 3   1 1 1 1 1 3 1 3 1 1 1 3 ...
Need Help
Show and Tell
Tips and Tricks
  • smpa01's avatar
    smpa01
    5 years ago

    siva_powerbi  that is because you did not provide the record for the whole row to be replaced

    Table.ReplaceMatchingRows( #"Changed Type",{{[order = 1,item=1,quantity=1,serial=1],[order = 0,item=1,quantity=1,serial=1]}})

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

siva_powerbi  that is because you did not provide the record for the whole row to be replaced

Table.ReplaceMatchingRows( #"Changed Type",{{[order = 1,item=1,quantity=1,serial=1],[order = 0,item=1,quantity=1,serial=1]}})

 

  • siva_powerbi's avatar
    siva_powerbi
    Icon for Helper IV rankHelper IV
    5 years ago

    Thanks for the solution its working but my requirement is dynamic is their any way that we can replace all values in column with out matching and not using the table.replacevalues.