Understanding Enumerations in Power Query M

[@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!

[@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’

[@FredericLEGUEN-Excel]

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

[@BIGorilla]

Thanks Frederic!

[@FsoOmar]

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

[@BIGorilla]

Wow thanks! Enjoy 🎉 🙏

[@cristian.angyal]

Learned something new today! 💡 Thanks for sharing Rick!

[@BIGorilla]

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

[@Chillman666]

Pretty cool! Thank you

[@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!

[@karimallahwala7022]

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

[@BIGorilla]

My pleasure!

[@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

[@xaft]

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

[@YTNutflexPayb]

💚

[@BIGorilla]

🎉 cheers!

[@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 .