Column or measure to filter data from multiple tables?

[Anonymous]

Hi all, 

I have 3 tables connected using the same ID number. One contains the Age, one contains a score attributed to each ID, and the third a status of their work.

I would like to have a column that will have an outcome for each ID based on all 3 tables. Say for instance:

if (Table1. Age >18 and Table2.Score > 60 and Table3.Status = xyz) then "Subgroup 1", else if ....

I tried doing this in M (Advanced editor) but the condition applies only to the Source, and looks like I can't have more than one source to have a calculated column. Unless there is a way and I dont know it.

Table 1

ID     Age

Table 2

ID     Score

Table 3

ID Status

Is there a way I could have it in a column or measure? 

[waltheed]

Hi, 

If you have relationships between the tables, on the ID column in your case, you can use RELATED() to get related values from another table. If there is no relationship you can work around it by using LOOKUPVALUE() to get a value from another table, by looking up the ID.