Forum Discussion
Filter multiple tables and columns
Hi I have the following problem
i need the name of the customer
in Table Omission i want to create a column Name Project which shows the name of customer that is related to Project_id from table omiission
the formula needs to be like this:
If Omission Table (project_id)-->Project Table(project_end_customer_id)-->Table project_end_customer_id(id)-->Table Customer(id) is a match give me Table Customer(Name) as the result
in the photo is how the relationships are between the different tables and
kind regards
Anonymous,
Given the relationship, it seems that you may simply use RELATED Function.
Column = RELATED ( Customer[Name] )
2 Replies
- AnonymousNot applicable
Hi i have difficulties with looking up a value over multiple tables
I want to add a column in table Omission with the customer name from Table Customer
please see photo below for the relationships
P
- v-chuncz-msftCommunity Support
Anonymous,
Given the relationship, it seems that you may simply use RELATED Function.
Column = RELATED ( Customer[Name] )