Forum Discussion

Framboosje1's avatar
Framboosje1
Frequent Visitor
6 years ago
Solved

create relationship

Hi,   See picture below. what i want to create is a relationship between the merged table and table 1 so is can report on every column of table 1. 
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi  Framboosje1 ,

    start with a Base Table, disable the load and create two references (State and City)

    Disable the load for the references and dublicate the State/City Column.

    Rename this Column as StateCity

    Than Append this two tables as new query

     

    I updated the PBIX File

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi  Framboosje1 ,

start with a Base Table, disable the load and create two references (State and City)

Disable the load for the references and dublicate the State/City Column.

Rename this Column as StateCity

Than Append this two tables as new query

 

I updated the PBIX File

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Framboosje1's avatar
Framboosje1
Frequent Visitor
6 years ago

Last question 🙂

what should i do if i values in my merged table which are not unique to the Base Table. What should i do so i can create a many to one relationship.

 

example: instead of Ile de Paris - Paris i have Beieren - Munchen. what should i do(remove the not unique values or filter out something like that)

 

 

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Can you explain it with more sample data?