Forum Discussion
Comparing 2 tables
HI all
I have a question regarding comparing 2 tables. (same columns. The only difference is that in the Baseline we have the expected CUIDS x month and in the "Slipp Country " table we have th...
Hi Selimovd.
I was trying to use your formula but I get all YES. with the filter.
Matching Measure =
VAR vIntersectionTable =
INTERSECT (
SUMMARIZE ( 'Slippage Country', 'Slippage Country'[CUID Slippage Country], 'Slippage Country'[Month] ),
SUMMARIZE ( 'Baseline Country', 'Baseline Country'[CUID Baseline Country], 'Baseline Country'[Month] )
)
RETURN
IF( COUNTROWS( vIntersectionTable ) > 0, "Yes", "No" )
The idea is that not all CUIDs slipped, therefore No should be expected too.
Currently PowerBI is also adding some duplicated. Current VLOOKUP is checking CUIDS and also provides the ones that didn't slipped.
What am I trying to create like a double VLOOKUP with a formula that says.
IF the CUID and Month of table 1 (Baseline) EQUALS CUID and Month of table 2 (Slipapge), Yes, otherwise No.
Thanks