Forum Discussion

PbiCeo's avatar
PbiCeo
Helper II
6 years ago
Solved

Sort text by ascending and make nulls last

Hello everyone,   When I sort text by ascending, nulls come first like this:   null null A B C a b c   How can I make nulls last when I sort it by ascedning?   I could not find this fu...
Need Help
Tips and Tricks
  • Ajinkya369's avatar
    Ajinkya369
    6 years ago

    Hi PbiCeo  ,You can do this by adding a conditional column.

    I'm attaching the solved screenshots for your problem.

     

    Step1: Add condtional column and enter the detail as shown in the screenshot.

    Step2:Sort the Newly added condtional column in ascending order and its done.

    Step3:Now Sort the column in ascending where the alphabets are present.

    Step1

     

     

    Step2

     

    Step3

     

    if your problem is solved then please accept this as a solution.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

if your goal is to sort a list of strings, you could get the result without using auxiliary lists

 

 

let
    Source = {"A","C","a","b","B",null,"c",null},
    #"Sorted Items" = List.Sort(Source,(x,y)=>if x&y<> null then Value.Compare(x ,y) else Value.Compare(y ,x))
in
    #"Sorted Items"