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

Anonymous — Thu, 30 May 2024 15:07:18 GMT

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.

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

xifeng_L — Thu, 30 May 2024 15:21:59 GMT

Hi Anonymous ,

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~

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

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

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