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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
DiegoB
Frequent Visitor

Power query . Retrieve a value from other table

Hello, I nedd help for a problem that I couldn't solve.

 

I have a registration number in the table A 

Table A

DiegoB_0-1733136135047.png

I have to search this number in the interval on the table B and then I want to bring de date from the table B into table A.

Table B

DiegoB_1-1733136870162.png

 

I prefer do this in power query.

Could someone kindly help me?

 

1 ACCEPTED SOLUTION

@DiegoB 

 

In this case go to Table A add a customer column and use the below formula in this column

 

 

Table.SelectRows(tableb, (x)=> [data.entrynumber]>=x[from entry n] and [data.entrynumber]<=x[To entry n])

View solution in original post

4 REPLIES 4
Omid_Motamedise
Resident Rockstar
Resident Rockstar

It is easy in power query, just follow the below steps

 

1. Select table A

2. From home tab, peack Merge command, 

3. In the oppend window, in the below box select table B.

4. Select common colmin in both the table and press ok.

Thank you, i find a problem, because the value in the table A is a value between the value in the column "form entry n°" and the value "To entry n°" in the table B. And sometimes the value (table A) may be not be explicit in the table B.

 

@DiegoB 

 

In this case go to Table A add a customer column and use the below formula in this column

 

 

Table.SelectRows(tableb, (x)=> [data.entrynumber]>=x[from entry n] and [data.entrynumber]<=x[To entry n])

Thank you Omid, it works fine!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors