Forum Discussion
Create column with related fields from two 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...
Result = UNION('Table 2','Table 3')
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
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