March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
Hello, I nedd help for a problem that I couldn't solve.
I have a registration number in the table A
Table A
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
I prefer do this in power query.
Could someone kindly help me?
Solved! Go to Solution.
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])
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.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.