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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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