Create a column based on multiple tables

[pagliaci]

Hello all, 

I have one table called SAP - Production (Table1) that should create a new column returning if the checklist for each production line was filled or not. The problem is that I need to look into 4 other tables to return the value from the correponding line. 

So I have LV90 (table2), lv90(table3), lv94(table4), lv88(table5) that are all connected to SAP - Production and they have a column saying that my checklist is done, but I just need 1 column on my Table 1 that compares which line it is and just shows the corresponding checklist.

The result I should get on table 1:

[smpa01]

@pagliaci  okay let's suppose you have a master table as following

Column1

s1

s2

s3

s4

and three other tables; such as _t1,_t2 and _t3

CAT	isDone?
s1	Yes

CAT	isDone?
s2	Yes

CAT	isDone?
s3	Yes

you can achieve your end goal (havinf two calculated column in master) like following

isDone? = 
VAR _0 = MAXX ( FILTER ( _t1, _t1[CAT] = EARLIER ( master[Column1] ) ), _t1[isDone?] )   
VAR _1 = MAXX ( FILTER ( _t2, _t2[CAT] = EARLIER ( master[Column1] ) ), _t2[isDone?] ) 
VAR _2 = MAXX ( FILTER ( _t3, _t3[CAT] = EARLIER ( master[Column1] ) ), _t3[isDone?] )
VAR _3 = SWITCH(true(), _0<>BLANK(),_0, _1<>BLANK(), _1,_2<>BLANK(),_2)
RETURN _3

foundWhere? = 
VAR _0 = MAXX ( FILTER ( _t1, _t1[CAT] = EARLIER ( master[Column1] ) ), _t1[isDone?] )   
VAR _1 = MAXX ( FILTER ( _t2, _t2[CAT] = EARLIER ( master[Column1] ) ), _t2[isDone?] ) 
VAR _2 = MAXX ( FILTER ( _t3, _t3[CAT] = EARLIER ( master[Column1] ) ), _t3[isDone?] )
VAR _3 = SWITCH(true(), _0<>BLANK(),"t1", _1<>BLANK(), "t2",_2<>BLANK(),"t3")
RETURN _3