Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create new column with related fields from 2 tables (In Table view)

Hi, Table 1 contains Jobname column with X,Y,Z. I want to create another column Time in this table with related fields from other two tables matching this X,Y,Z. Table 2 contains time of X, Table 3 c...
  • mh2587's avatar
    mh2587
    1 year ago
    --Try this
Time = 
IF (
    NOT ( ISBLANK ( LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ) ) ),
    LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ),
    LOOKUPVALUE ( Table3[Time], Table3[jobname], Table1[jobname] )
)
mh2587's avatar
mh2587
Super User
1 year ago
--Try this
Time = 
IF (
    NOT ( ISBLANK ( LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ) ) ),
    LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ),
    LOOKUPVALUE ( Table3[Time], Table3[jobname], Table1[jobname] )
)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

It is not working for 4 tables. But working for 2 tables. For more than 3 tables? Can you show format?