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

Question

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 contains time of Y, Z.&nbsp;TABLE 1&nbsp;&nbsp;Table 2&nbsp;&nbsp;Table 3&nbsp;&nbsp;Result Table should be like thisjobnameTime&nbsp;jobnameTime&nbsp;jobname&nbsp;&nbsp;jobnameTimeX&nbsp;&nbsp;X9:00 AM&nbsp;Y10:00 PM&nbsp;X9:00 AMY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Z11:00 AM&nbsp;Y10:00 PMZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Z11:00 AM

mh2587 · Accepted Answer

--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] )
)

Forum Discussion

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

2 Replies

Related content

Create columns group

Unable to create Date Dimension and Date related measures

Filtercontext with date relation

Create Calculated Column from Related Table

Calculated Column using RELATED

TABLE 1		Table 2		Table 3		Result Table should be like this
jobname	Time	jobname	Time	jobname		jobname	Time
X		X	9:00 AM	Y	10:00 PM	X	9:00 AM
Y				Z	11:00 AM	Y	10:00 PM
Z						Z	11:00 AM