Error de ordenación

[JuanEsteban10]

Hola, estoy tratando de establecer un orden personalizado en mi tabla.

Cree un índice y cuando le digo a la tabla que ordene por ese indice me sale un error que no entiendo, no hay ningún valor duplicado en el índice.

Alguien sabe a que se pueda deber?

[Anonymous · Accepted solution]

Hi, @JuanEsteban10 

The error message indicates that there is a duplicate value in the Order column. That is, there are multiple entries with different sequential values for a certain "Account Name", which causes sorting issues. Make sure that each Account Name has only one unique "Order" value. Or modify the Order value so that each Account Name has only one corresponding Order value. If possible, choose a column that doesn't have this problem to sort.

You can also go directly to PowerQuery to create an Index column and change it to Order:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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