Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to Solution.
--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] )
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
--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] )
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
It is not working for 4 tables. But working for 2 tables. For more than 3 tables? Can you show format?
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |