Replace Values based on another table

[joshua1990]

hi all!

What is the best way in a dataflow to replace the values from 1 column with the value from another table?

I have a table with product | value. Then I have another table that only contains an entry if it is required to be replaced in the first table.

What would be the best way to do this?

[v-veshwara-msft]

Hi @joshua1990 ,

We’re following up once more regarding your query. If the provided responses were helpful, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.

Best regards,
Vinay.

[v-veshwara-msft]

Hi @joshua1990 ,

We wanted to check in again to see if you’ve found a solution. If so, please mark the helpful reply as the Accepted Solution to assist others with similar issues. If you still need help, feel free to reach out for further assistance.

Best regards,
Vinay.

[v-veshwara-msft]

Hi @joshua1990 ,

Just following up on your query to see if you’ve found a solution. If so, please mark the helpful reply as the Accepted Solution to assist others with similar issues. If you still need help, feel free to reach out for further assistance.

Best regards,
Vinay.

[v-veshwara-msft]

hi @joshua1990 ,
Thanks for posting in Microsoft Fabric Community,
As suggested by @Greg_Deckler Merge Queries would be the common approach in this case.
I have created some sample data and reproduced the sceanrio as below:
1. Created Main table and replacement table as follows:

   
2. Merged both tables with Product column as key and used Left Outer Join. This creates a column NewValue in Main table.

3. Added a Custom Column:
Expression: if [NewValue] <> null then [NewValue] else [Value]
This replaces values only where NewValue is available.

Remove the original Value and NewValue columns and renamed the new column as Replacedcolumn.

This way we can use Merge Queries and Custom Column to replace values from another table.

Hope this helps. If further assistance is needed please reach out by providing some sample data and also the required output to assist better.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best regards,
Vinay.

[Greg_Deckler · Accepted solution]

@joshua1990 So, generally, you would use a Merge query for something like that but hard to know without more information and example data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.