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

[Anonymous]

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. 

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

[lbendlin · Accepted solution]

Result = UNION('Table 2','Table 3')

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to provide another insight: 
Hi @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Time =
var _table2=
MINX(
    FILTER(ALL('Table2'),'Table2'[jobname]=EARLIER('Table1'[jobname])),[Time])
return
IF(
    _table2=BLANK(),
 MINX(
    FILTER(ALL('Table3'),'Table3'[jobname]=EARLIER('Table1'[jobname])),[Time]) ,_table2
)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin · Accepted solution]

Result = UNION('Table 2','Table 3')