Forum Discussion
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.
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.
Can you explain it with more sample data?
Sorry, but i don't understand the problem.
Why is Osaka not in the StateCity column of the merged table?
You know that you can edit the relationship?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.