Filter multiple tables and columns

[Anonymous]

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]

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-msft · Accepted solution]

@Anonymous,

Given the relationship, it seems that you may simply use RELATED Function.

Column =
RELATED ( Customer[Name] )