Sort text by ascending and make nulls last

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.

Hi PbiCeo ,

It wont work if you are using the direct query method.

Yes there is another way to acheive this,please follow the video link below:

https://www.youtube.com/watch?v=n_gnuFS8qoY&feature=youtu.be

Thank you

Ajinkya Kadam(Analytical specialist)