Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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 to replace rows 1 for Order and 1 and 3 of Seria
I choose to use the Table.ReplaceMatchingRows function but unfortunately function doesn't return the required output neither throws error. Statement I am using
Table.ReplaceMatchingRows(#"Renamed Columns",{{[Order = 1],[Order = 0]}})
Above statement didn't throw any error neither it replace values to 0, above statement is a example one as I get the columns to be replace dynamically through parameters.
Thanks
Siva
Solved! Go to Solution.
@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 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]}})
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.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 14 | |
| 9 | |
| 8 | |
| 7 |