Forum Discussion
Solved
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 I have to search this number in the interval on the table B and then I want to...
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])
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!