Forum Discussion
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)
You can also do something like this:
= List.Sort(
{"A","C","a","b","B",null,"c",null, "b", null },
( x,y) => Value.Compare( x??"~",
y??"~"
)
)
This treats the null values as if it's a "~" value. From all values, this values sort at the bottom.
For more on list functions you can read:
https://gorilla.bi/power-query/list-functions/
Enjoy!
--------------------------------------------------
@ me in replies or I'll lose your thread
Master Power Query M? -> https://powerquery.how
Read in-depth articles? -> BI Gorilla
Youtube Channel: BI Gorilla
If this post helps, then please consider accepting it as the solution to help other members find it more quickly.