Forum Discussion

Lidou_Cand's avatar
Lidou_Cand
Helper III
5 years ago

calculated column with values from another table

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Lidou_Cand ,

     

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

     

    Cheers

     

    CheenuSing

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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