topic Create new column with related fields from 2 tables (In Table view) in DAX Commands and Tips

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

Anonymous — Fri, 11 Oct 2024 17:09:02 GMT

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

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

mh2587 — Fri, 11 Oct 2024 17:14:55 GMT

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

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

Anonymous — Fri, 11 Oct 2024 19:58:36 GMT

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