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.

Ajinkya369's avatar
Ajinkya369
Resolver III
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.

  • PbiCeo's avatar
    PbiCeo
    Helper II
    6 years ago

    Hello Ajinkya369 , 

    By the way, does it work for DirectQuery, too?

    If not, is there any way for DQ?