Creating custom column in a table from columns of other table

[ssai]

Hello community 🙂

I want to create a custom column in table A which is a copy of the column that is already present in table B. Is there any way out to solving this issue. 

Thanks in advance ...

[ssai]

Hi @Arul  Yes i have one common column between them.

[Arul · Accepted solution]

@ssai ,

then use lookup and create a column,

https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
https://dax.guide/lookupvalue/

Thanks,

Arul

[Arul]

@ssai ,

Do you have any common keys between those tables?

Thanks,

Arul