How to copy a column from table 1 to table 2? Table 2 is updated itself when table 1 is updated.

[rickylee]

Hello, 

I am unsure if this is possible.
I have table 1 which is from a database. When the data goes to power bi, I would like to copy column1 from table1 into table2 which is a table I created in powerbi only. Then, whenever column1 in table 1 is updated or new data is coming in, the column in table 2 is automatically updated.

Is it possible and does it take long to implment this?

Thanks,
Ricky

[sokg]

Is there any relationship between these two tables???

[rickylee]

Hi,

Yes, the column I am trying to copy is actually an ID. In the future, a relationship will be formed and the key is ID. Are there any difference if there is a relationship/isn't a relationship?

Thanks,
Ricky

[sokg · Accepted solution]

If you have a relationship between table 1 and table 2 you can use RELATED function . But as I understand you don't have a relationship. So try to use LOOKUPVALUE.

Information about these two fuctions below

https://msdn.microsoft.com/en-us/query-bi/dax/related-function-dax

https://msdn.microsoft.com/en-us/query-bi/dax/lookupvalue-function-dax