Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
75 | |
69 | |
66 |
User | Count |
---|---|
214 | |
128 | |
117 | |
82 | |
76 |