Forum Discussion

twister8889's avatar
twister8889
Icon for Helper V rankHelper V
5 years ago
Solved

Order column text and number

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 ot...
Need Help
  • twister8889's avatar
    twister8889
    5 years ago

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

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
twister8889
Icon for Helper V rankHelper V
5 years ago

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