Result by order

[godtooro]

Dear all,

First of all, thank you for your support.

I've the next tariff structure:

I want to obtain the first result althoug the tariff code doesn´t have the less number because must apply by tariff code order.

How do I can obtain the result?

[godtooro]

Dear @v-xinruzhu-msft thank you for your support.
One step ahead I'd like to obtain only one result, the price of the mininum LCV order and I'm trying this:

I'm obtaining this but I only want the result of the 100 level order that is the minimum :

[v-xinruzhu-msft]

Hi @godtooro 

Do you want to sort the numbers according to the order column? If so, you can directly click the order column to sort in ascending order. If not, can you provide some more detailed descriptions? Based on your current description, I don’t quite understand what you need or can you provide some example images.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[godtooro]

Hi @v-xinruzhu-msft !!

Thank you for your support.

The question is that I've thousand of references and I what I nedd is to see an unique result that corresponds to the Tariff order code and besides the minimum Tariff code order is not always 100 could be 80, 50...whatever

How can I obtain the valeu of the minimum tariff order?

From this:

To this:

[v-xinruzhu-msft]

Hi @godtooro 

You can create a rank column

Column = RANKX(FILTER('Table',[Product id]=EARLIER('Table'[Product id])),[Tariff code order],,ASC,Dense)

Then filter the column "Rank"=1

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.