Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
romovaro
Responsive Resident
Responsive Resident

intercept - double vlookup with 2 requirements

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 the CUIDs that slipped)

 

What am I trying to create is a formula that says.

 

IF the CUID and Month of table 1 (Baseline) = CUID and Month of table 2 (Slipapge), Yes, otherwise No

 

Tried diff options but not working so far...

 

 

Matching Measure =
VAR vIntersectionTable =
INTERSECT (
    SUMMARIZE ( 'Baseline Country', 'Baseline Country'[CUID], 'Baseline Country'[Month]),
    SUMMARIZE ( 'Slippage Country', 'Slippage Country'[CUID], 'Slippage Country'[Month])
)
RETURN
IF(COUNTROWS( vIntersectionTable ) > 0, "Yes", "No" )
 
Thanks

 

 
0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.