Showing results for 
Search instead for 
Did you mean: 

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!





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,


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,

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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors