Forum Discussion

cinthiafkc's avatar
cinthiafkc
New Member
4 years ago
Solved

Relationship between three tables

Hi everyone!   I have a Fact table with a column which contain a foreign key. This column may contain IDs that references to the Dimension City Table (whose DID countains 7 digits) or to the State...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi cinthiafkc ,

     

    Please follow these steps:

     

    1. Add a Custom column based on the length of the ID_Entity column:

    =if Text.Length(  Number.ToText( [ID_Entity])  )=2 then "ID_State" else "ID_City"

    2.Click Custom column-->Pivot columns-->use ID_Entity as Values

     

    After applying these changes, the relationships would be automatically built:

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi cinthiafkc ,

 

Please follow these steps:

 

1. Add a Custom column based on the length of the ID_Entity column:

=if Text.Length(  Number.ToText( [ID_Entity])  )=2 then "ID_State" else "ID_City"

2.Click Custom column-->Pivot columns-->use ID_Entity as Values

 

After applying these changes, the relationships would be automatically built:

 

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