Dax formula that will find next order in list who's order weight is less than or equal to current or

[JAKEPBI]

Hello,

I have a table with order ID's, order weight, and weight needed columns. I would like to create logic that will look at the current order and search the list for an order who's order weight value is less than or equal to the current order's order needed value. I have included an example of the table I am looking to create below:

Order ID	Order Weight	Weight Needed	Suggested Pool Order
A	40000	5000	B
B	2000	43000
C	38000	7000	B

I would like to find a formula that creates the "Suggested Pool Order" column.

[xifeng_L · Accepted solution]

Hi @JAKEPBI ,

You can refer to below calculated column expression.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~