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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply

LOOKUPVALUE doens't work

unique ID.JPG Table A

result table.JPGTable B

 

Dear experts,

 

I have two tables A, B connected by bridge relationship through the bridge table with unique ID.

 

Table A contains column ID: unique ID values, and column Type: repeated values and column Date: repeated values.

Table B contains column ID: repeated values.

 

I want to LOOKUPVALUE of Type and Date from A to B but I only made it with Type, and when it comes to Date, it warns:

 

A table of multiple values was supplied where a single value was expected

 

I am confused and would very much be appreciated if anyone gives me some insights, or other solution.

 

Many thanks!

 

2 REPLIES 2
v-haibl-msft
Microsoft Employee
Microsoft Employee

@BusinessAnalyst

 

I tried with your Table A and Table B with NO relationship between them. It seems that the LOOKUPVALUE function works well.

I’ve uploaded my .pbix file here for reference. Could you please take a look at it to see if there is any difference between us?

 

Type_Column = 
LOOKUPVALUE ( 'Table A'[Type], 'Table A'[ID], 'Table B'[ID] )
Date_Column = 
LOOKUPVALUE ( 'Table A'[Date], 'Table A'[ID], 'Table B'[ID] )

LOOKUPVALUE doens't work_1.jpg

 

Best Regards,

Herbert

BhaveshPatel
Community Champion
Community Champion

Hi There,

 

PowerQuery is handy, quick and easy solution for such scenarios.

As shown in the screen shot, Go to the Query mode and In the Home Tab, Go to the Last section Combine. Click Merge Queries as New in here and select the Right Outer Join. 

Expand the column and Delete the newly created column. This will give you the results expected.M1.PNGm2.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors