calculated column to show ranking

[Anonymous]

Hello all,

Hope you are well.

I need to create a calculated column that will return the ranking of the extractin date column, 1 being the newest extraction date.

The first three columns of the below table can be considered as the extracted details, and the ranking column shows the desired calculated column.

Extraction Date	Product	Quantity	Ranking
23/11/2021	Prod01	65	1
23/11/2021	Prod02	43	1
23/11/2021	Prod03	96	1
05/11/2021	Prod01	65	2
05/11/2021	Prod02	40	2
05/11/2021	Prod03	100	2
15/10/2021	Prod01	70	3
15/10/2021	Prod02	34	3
15/10/2021	Prod03	86	3

Any help would really be appreciated.

Kind regards,

George

[Anonymous]

Hello @DimaMD ,

Thank you for your reply.

I produced your suggested measure.

Indeed, it returned the ranking , but unfortunately not in a consecutive order.

Do you have any idea how this can be fixed?

Thank you,

George

[Anonymous · Accepted solution]

Hello @DimaMD ,

I found the solution, please see the below screenshot.

As we can see, it returns the ranking in a consecutive order.

Thank you,

George

[DimaMD]

hi @Anonymous 
Good job, I led you to the right solution to your problem

[DimaMD]

hi @Anonymous 
Try it

Стовпець = RANKX('Table',[Extraction Date])