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.
Table 1:
A | B |
A1 | 100 |
A2 | 200 |
A3 | 300 |
Table 2
A |
A2 |
A5 |
A4 |
I need to compare table 1 and 2 (IMP: no relationship between them), then return column B for similar values of column A in both tables.
Can anyone help me?
Solved! Go to Solution.
You could try
B =
CALCULATE ( MAX ( 'Table 1'[B] ), TREATAS ( { 'Table 2'[A] }, 'Table 1'[A] ) )
You're adding it as a column in Table 2, not as a measure ? And you have the { } around the column reference ?
You could try
B =
CALCULATE ( MAX ( 'Table 1'[B] ), TREATAS ( { 'Table 2'[A] }, 'Table 1'[A] ) )
Thanks for the suggestion.
I tried this, but my column is not identifying inside 'Treatas'. I tried with 'Values' but no use. Column A in both tables are in TEXT format.
You're adding it as a column in Table 2, not as a measure ? And you have the { } around the column reference ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |