Forum Discussion

gooranga1's avatar
gooranga1
Power Participant
6 years ago
Solved

Sort by column error in Excel power query

Getting an error when trying to sort day name by day of week in Excel power query. Anyone else had this?     ============================ Error Message: ============================ The e...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi gooranga1 

    For the same [day of week], there are many same values of [day name sort].

    It may cause the error when sorting.

    Please assign other columns along with the [day of week] to sort [day name sort], like combine [day of week] and [number of week in a year] to sort [day name sort].

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi gooranga1 

For the same [day of week], there are many same values of [day name sort].

It may cause the error when sorting.

Please assign other columns along with the [day of week] to sort [day name sort], like combine [day of week] and [number of week in a year] to sort [day name sort].

 

Best Regards

Maggie

  • gooranga1's avatar
    gooranga1
    Power Participant
    6 years ago

    oh ok. that is different to how power bi desktop works then which just needs the 2 columns to have only unique pairings so 1 is always Monday for instance.

     

    Thanks