Order column text and number

[twister8889]

Hi guys,

I have a Column with text and numbers values, this column was created in power query, I would like to order this column by the first line with text value (Due) and order by number for others values, its is possible?

Column	Result
Due	Due
31/12/2021	01/07/2021
31/10/2025	01/09/2021
31/10/2024	01/10/2021
31/10/2023	01/12/2021
31/10/2022	01/12/2025
31/08/2024	02/07/2021
31/08/2023	31/08/2023
02/07/2021	31/08/2024
01/12/2025	31/10/2022
01/12/2021	31/10/2023
01/10/2021	31/10/2024
01/09/2021	31/10/2025
01/07/2021	31/12/2021

[v-xulin-mstf]

Hi @twister8889,

When a column contains both text and values, the entire column will be in text format.You define the value of the text first, and then sort the whole column

Just like:

Column = 
SWITCH(
    'Table'[Column1],
    "Due",1,
    "Text1",2,
    "Text2",3,
    0
)

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[twister8889 · Accepted solution]

First of all, thank you for your answer...
I solved the problem, creating the new column in power query to sort the columns