Understanding Enumerations in Power Query M

Enumerations allows you to provide instructions to functions in a readable way. In this video we delve into what enumerations are, how you can apply them and what they are syntax sugar for.
You can buy the Definitive Guide to Power Query M here: geni.us/ODZl8
WRITTEN ARTICLE:
powerquery.how/enumerations/
Master Functions and Syntax in M
powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
th-cam.com/users/bigorilla?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#enumerations #powerquery #bigorilla

[@SndfOmar]

Awesome, thanks Rick, you're the best in PQ.

[@BIGorilla]

Wow thanks! Enjoy 🎉
🙏

[@raimundojs9547]

Rick, definitely you're one of a kind. Deep, organized, clear and useful content. I've been learning a lot from you about M language. Respect and gratitude.

[@BIGorilla]

I appreciate that raimundo. I’m having some time off, but soon getting ready for the next range of videos!

[@Chillman666]

Pretty cool! Thank you

[@GrainneDuggan_Excel]

Thanks Rick! This video really demonstrates enumeration are syntax sugar for the underlying number.

[@BIGorilla]

Syntax sugar and syntax sugar only. We can even define our own variable name an integer, and use it as ‘custom enumeration’

[@kiranmai8773]

I want to sort data which is present in the form
1. x7
1. x1
1. x10
1. h1
2. tz
2. tm
2. ta
To the below outpot
1. h1
1. x1
1. x7
1. x10
2. ta
2. tm
2. tz
I have used ascending order, but I'm getting output in expected order.

[@FredericLEGUEN-Excel]

Nice presentation of a new concept of Power Query. Thanks Rick 👍

[@BIGorilla]

Thanks Frederic!

[@cristian.angyal]

Learned something new today! 💡
Thanks for sharing Rick!

[@BIGorilla]

Glad to hear it buddy! Hope to see you again soon😁

[@karimallahwala7022]

Thank very much for your great content of your Videos and the Website.

[@BIGorilla]

My pleasure!

[@MrJamesbotes]

great insight! your book and PQ How Site is great man! deep dive into M!

[@BIGorilla]

Appreciate that James, awesome! Make the world better step by steps, by teaching more people Power Query M!

[@xaft]

Will there therapy be a digital book or it is on kindle??

[@YTNutflexPayb]

💚

[@BIGorilla]

🎉 cheers!

[@bob-tina]

Hoi Rick, mooie ideeën en inzichten in deze video! Is het ook mogelijk custom Enums te maken?

[@BIGorilla]

Hey bob - ja dat is geen probleem. Als je een variabele aanmaakt met de gewenste naam en je hangt er een 0 of een 1 aan bijvoorbeeld, dan kun je deze alternatieve naam gebruiken als de enumeratie. 😁

[@bob-tina]

Dankjewel voor de tip

[@williamarthur4801]

Did not know there was a add rank column, one question, some you add jus as text so;
Groupkind.local, but others need to be as a record [RankKind = RankKind.Competition] ? ,
and while I'm here ;
functions, add colunn (
each Text.Split([Name], ",")).
or
each Splitter.SplitTextByAnyDelimiter( {","} ) )
is the first just sugar for latter? re splitter's thanks for the help re current, old new .