Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Select Two Column Into One Through Relationship
05-21-2018
10:11 AM
How can I select data from two columns in different tables, in a column for a third table through relationships?
I'm using SSAS.
Like this:
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2018
10:44 AM
Hey,
you could use the DAX function RELATED (https://msdn.microsoft.com/en-us/query-bi/dax/related-function-dax) when creating a calculated column and all the tables are related. It seems somewhat peculiar (at least for a Power BI datamodel) that table B is related to both tables (A and C) using column [ID].
It's more common to create a star schema in Power BI.
Maybe you can consider to create a relationship between table A and C, a 1 to 1 relationship.
Hopefully this gives you some ideas
Regards
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-18-2024 01:23 AM | |||
08-21-2024 11:09 PM | |||
06-07-2024 02:28 AM | |||
05-18-2024 10:08 AM | |||
07-08-2024 09:12 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |