HOW TO COPY A DATA COLUMN FROM ANOTHER TABLE!

[SRBI]

Hi Friends

I need to copy a Column(with data) from one table to another .. how it is possible ?

Regards

[v-deddai1-msft · Accepted solution]

Hi @SRBI ,

It depends on whether there is a correspondence between the two tables. If so, you can use merge query or create calculated column by RLATED function.  https://radacad.com/append-vs-merge-in-power-bi-and-power-query

If not, you can create index columns in both table and :

Then use lookupvalue function:

Column = LOOKUPVALUE(Table2[Column1],Table2[Index],'Table'[Index])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@SRBI , In power query you have merge two table and then choose the column you need.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

in Dax there are few way - refer to my video : https://www.youtube.com/watch?v=czNHt7UXIe8

[mahoneypat]

There are a few potential ways to do this (e.g., merge, add as custom column, use Table.FromColumns).  Please explain further with example/mock tables.

Regards,

Pat