Forum Discussion
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.
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.
9 Replies
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.
your solution looks good but can you share with me the pbix file.
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.
