topic Re: calculated column to show ranking in DAX Commands and Tips

calculated column to show ranking

Anonymous — Tue, 23 Nov 2021 10:08:35 GMT

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.

Any help would really be appreciated.

Kind regards,

George

DimaMD — Tue, 23 Nov 2021 10:21:43 GMT

hi Anonymous
Try it

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

Anonymous — Tue, 23 Nov 2021 10:58:41 GMT

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 — Tue, 23 Nov 2021 11:15:17 GMT

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 — Tue, 23 Nov 2021 14:07:51 GMT

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