Forum Discussion
how to replace some values in one table with values from another table
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
Microsoft EmployeeHi 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
Hi Dale!
I have the same problem, but with a big BUT. Second table with correct values is DirectQuery, so I can't just manually merge them and kill some bad values. I have a table with data of a stores visitation for 8 stores< but 2 of them are inaccurate and should be replaced with data from calculated table (sourced from DirectQuery). So I think it can be somehow solved with Power Query M functions, but have no idea how.
Both tables are 3 columns: Date, Store Number, Visitation.
I'm almost lost any hope of solving it.
Best regards, Taras