Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 3 related tables. I am trying to create a new column based on values from the other 2 tables.
Table A
Name | Old Code |
Mickey Mouse | 11111 |
Donald Duck | 11111 |
Iron Man | 22222 |
Captain America | 33333 |
Black Widow | 44444 |
Iron Man | 55555 |
Table B
Original Code | New Code |
11111 | 12345 |
22222 | 23456 |
33333 | 34567 |
44444 | 45678 |
55555 | 56789 |
Table C
Name | Type | Code |
Mickey Mouse | Disney | 77777 |
Donald Duck | Disney | 77777 |
Superman | DC Comics | 88888 |
Iron Man | Marvel | See Table B |
Captain America | Marvel | See Table B |
Black Widow | Marvel | See Table B |
Something similar to:
IF ('Table C'[Type] = "Marvel" THEN 'Table B'[New Code]) , ELSE 'Table C'[Code]
Here are the reulst for these sample Tables
Name | Original Code | NEW Code Results |
Mickey Mouse | 11111 | 77777 |
Donald Duck | 11111 | 77777 |
Superman | 22222 | 88888 |
Iron Man | 22222 | 23456 |
Captain America | 33333 | 34567 |
Black Widow | 44444 | 45678 |
Iron Man | 55555 | 56789 |
Solved! Go to Solution.
@adoster Maybe:
Column =
IF (RELATED('Table C'[Type]) = "Marvel", RELATED('Table B'[New Code]),RELATED('Table C'[Type]))
@adoster Maybe:
Column =
IF (RELATED('Table C'[Type]) = "Marvel", RELATED('Table B'[New Code]),RELATED('Table C'[Type]))
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |