Using RANKX for Multiple Parameters

[burakkaragoz]

Hello,

In the table below I need the earliest date of the inventory number which is in the negative balance. I tried the Rankx formula a lot but couldn't find a solution.

I can exemplify the table I want to see in this way, but when listing here, it must not start from the earliest date.

Thank you for your support.

[burakkaragoz]

Dear @Ahmedx 

Problem is solved.
Thank you for your support.

[Ahmedx · Accepted solution]

Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26RhjnFeg8B9QhRvQHM?e=oqtdSb