Pulling a text value from another table column

[Redfox_delta1]

Without merging two unrelated tables is there a dax function which will pull the text source from one column from a table and then insert the same text source into a new column in a different table.

[Ashish_Mathur · Accepted solution]

Hi,

As long as there is at least one connecting column between the 2 tables and in the table (from where you are bringing over the column) has only one entry for the lookup value, you may use the LOOKUPVALUE() function.  

[Redfox_delta1]

@Ashish_Mathur  yep that worked thank you

[Ashish_Mathur]

You are welcome.