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
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Framboosje1 ,

 

you have to create a column StateCity

 

 

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

your solution looks good but can you share with me the pbix file.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi Framboosje1 ,

     

    here my quick & dirty PBIX File.

     

    You should generate table 1 in Power Query. (with append queries)

     

    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

      thanks for the pbix but can you explain to me how to create in PowerQuery. 

      thanks in advance

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost 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.