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 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 |
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
2 Replies
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