Medida de Ranks

Sonia_herrera — Mon, 12 Feb 2024 23:52:26 GMT

Buenas noches,

alguno me podría ayudar a sacar la medida de ranking , por meses, por trabajador de acuerdo al promedio general de notas de cada uno de estos.

les agradezco su ayuda

Re: Medida de Ranks

Anonymous — Tue, 13 Feb 2024 06:07:45 GMT

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Open power query and group by marca temporal and Nombre_Apellido_funcionario

Create claculate column

Merge = FORMAT('Table'[Marca temporal],"yyyymmdd")

Merged = CONCATENATE('Table'[Merge],'Table'[Sum])

Rank = RANKX('Table','Table'[Merged],,ASC)

Final output

Best regards,

Albert He

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