Forum Discussion
Creating a new table using existing tables
Hi,
I am trying to create a table that is a data dictionary. I have 3 tables that relate to one other, but 2 dont have any relatable fields. For example Table 1 and Table 2 join on name, Table 2 and Table 3 join on Email. I need Table 1 and Table 3 to join so Table 3 can filter Table 1. I can't do this in relationships (if you think i can could you please help), so I have decided it needs a joining table. I want a table that has Name from Table 3, Name from table 2, Email from table 2, and Email from table 1. so it creates that connection. Then i can use that as the connecting table to build a relationship between table 1 and table 3.
Hope that makes sense! Any advice welcome, i'm new to power bi!
Thanks,
Amy
You generally want to do this in Power Query, which is designed for data modeling. This article by Microsoft will explain how. It uses Power Query in Excel, but it is identical to how Power Query in Power BI works.
If you still need help Anonymous please post some data via the methods in the links below so we can assist.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forumhi Anonymous
Table 1 and Table 2 join on name, Table 2 and Table 3 join on Email.
Just set cross filter direction is "Both" for these two relationship, then Table 3 can filter Table 1
Regards,
Lin
3 Replies
You generally want to do this in Power Query, which is designed for data modeling. This article by Microsoft will explain how. It uses Power Query in Excel, but it is identical to how Power Query in Power BI works.
If you still need help Anonymous please post some data via the methods in the links below so we can assist.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumAnonymous , if this a 1-M relation like table 1 to table 2 and table 2 to table 3
or table 3 to table 2 and Table 2 to table 1.
Then you should be able to work with visual even without merge.
If you still need to do that
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
hi Anonymous
Table 1 and Table 2 join on name, Table 2 and Table 3 join on Email.
Just set cross filter direction is "Both" for these two relationship, then Table 3 can filter Table 1
Regards,
Lin
