Understanding List Sort in Power Query

Learn to master the List.Sort function in Power Query. Create custom sort orders using the comparison criteria for advanced data sorting, beyond the basics.

WRITTEN ARTICLE

Master Functions and Syntax in M

CONTENTS
00:00 Introduction
00:47 Sorting Arguments
01:42 Null values
03:56 Letters
04:13 Numbers as Text
05:54 Upper and Lowercase
06:53 Custom Text Sort
08:14 Day Names
12:37 Date Variations

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#Sorting #powerquery #bigorilla

[BIGorilla]

See more examples and copy the code at my blog:

[raitup]

I learn a lot of Power query with your videos!

[ThepExcel]

wow, very great tutorial for me. learn a lot from this one

[Ratnakumarwrites]

Thanks Rick learning from you is fun & intresting...

[williamarthur]

Not quite finished watching, but thanks for an afternoon of rabbit holes, read your article on coalesce,
and went down a few paths that I thought of on the way, including zipping dates and years and stuff.

[Bondoz]

That was great = thanks Rick. So just to be clear, you are creating this columns instead of the "sort" columns we need to made labels and dates sort correctly in data visuals (you called them helper columns) - correct. So I'm guessing once one has created the List.Sort column, one can remove the original column the sort is based on, and just use the List.Sort column going forward? So the model will run better/less unnecessary data columns?

[MrMoustafaaziz]

How can I maintain the original table data sort in PowerQery? Could you help please

[williamarthur]

I think you should do a video on when to use List.transform with functions like Number.From(_),
I always think I have to if the function being used does not have the word list in it.
List.Sort( List.Transform ( {"1", "10", "2", "22", "11" }, (_)=> Number.From(_)) )
Which obviously does change the data type. Gets a bit confusing, keep up the good work, REALLY like your COMPUTERGAGA vid on list.generate. 😊😊