Forum Discussion
Solved
Merge two tables by value range
Howdy! I have two tables: Table A Name Amount Bob 1.000 Joe 2.500 Billy 3.000 Frank 3.500 Joy 6.000 Table B Amount Rates 0 0 1.125 1 2.000 2 3.00...
Hi,
to obtain this
you need to add a custom column
(OuterTable)=> List.Last( Table.SelectRows( Rates, (InnerTable)=> InnerTable[Amount]<=OuterTable[Amount])[Rates])
it is better also to sort column Amount in Rates and to buffer the table to optimize the query
= Table.Buffer( #"Sorted Rows")
You can find a fantastic explanation of it (which i have apllied here) in
Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12
https://www.youtube.com/watch?v=3ZkIwKBVkVE
by Excellisfun
It is the last argument of a long video
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
