Forum Discussion
how to replace some values in one table with values from another table
I have a source table that I need to "clean up". The clean-up operation must be done entirely in Power BI. In particular, I need to correct some values in a column. The correct values are stored in a...
Hi Anonymous,
You can apply the same solution in the Power BI Desktop.
1. Open the Query Editor;
2. Merge the two queries as one;
3. Add a custom column;
4. Delete the unwanted columns.
You can find a demo in the attachment.
Best Regards,
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Could you please mark the proper answer as solution?
Best Regards,
Dale