calculated column with values from another table

[Lidou_Cand]

HelIo All,

I have a question about the calculated columns.
In a star model,is it possible to create a column calculated in a dimension A
with fields from another dimension B?
How do I join between the two dimensions?

[v-shex-msft]

Hi @Lidou_Cand,

Did these fields stored as multiple value fields or hierarchy fields? AFAIK, current power bi does not support building relationships on the hierarchy field. 

If you are work with common table fields, you can add a calculated column to lookup corresponding value and use it as a key to building relationships.

Please provide more detailed information to help us clarify your scenario:

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[CheenuSing]

Hi @Lidou_Cand ,

Can you share more details about your requirement.  Table structures, output epected etc

Cheers

CheenuSing