Learn Power Query's M Language in 2024

Latest Update: The course is launched!

In this comprehensive guide, you will learn how to master the M Code in Power Query. Whether you're a beginner or an experienced user, these five structured ideas will help you unlock the full potential of Power Query and take your data-wrangling skills to the next level.
#powerquery #mlanguage #dataanalysis

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[GoodlyChandeep]

Latest Update: The course is launched!

[Sumanth]

Great session..Error is as the value is not in text format. Corrected formula : Text.End(Text.From([Cost]), 1)

[JJ_TheGreat]

5:47 The pound sign (#) with the quotation marks is used when the name of your step contains a space (which usually means more than one word, but technically, you don’t have to name your steps with words, so therefore - if there is a space (“ “) in the name, that is why the M language - even through the interface - defaults to the #”[insert characters with at least one space here]” format).

[philipmarno]

Just wanted to thank you for this in-site, the structure of your training is fantastic.
I have just recently started to use power query after many years of Excel and this has been great, please keep up the great work. I will say I’m no spring chicken but get a real thrill in learning something new. 2024 is Power Query year.

[dixcyrajesh]

Reason for error:-

Column [cost] has data type of whole number.

And as we know data types in power query is very strict in nature.


We can't add text data types with number data types

So, formula to work in custom column will be as per below


Text.End(Number.ToText([cost]), 1)


As here inner function will convert each value in column which is in whole number data type to text data type.

Then outer function will take that output as input because text function expect input as text data type.

And finally we will recieve the desired output which will last single value to be extracted from entire value in each row of the cost column




Thanks

[arturocdb]

Thank you so much for your videos. M Language and Power query was opaque by Microsoft it self with the launch of dax and power bi, but m language its so powerful and simple to use that so much to explore in 2024.

[KuldeepSingh-nqvi]

Error is occuring due to data type mismatch, glad to hear you are creating M language Videos..

[sujit]

Beginning of new era with m code with you soon

[raimundojs]

Great! Excellent news about the M course!

[JJ_TheGreat]

9:00 I use Power Query as a tool in my work as an internal auditor - to import and clean data up, so that I can pick samples. For what I do, I still use the UI, as it is enough to produce a query which I can use. However, I started getting really good at using the interface - and this year, for one of the reviews which is more data-centric, I was able to copy some query codes using the Advanced Editor (after making/making sure the data is in the same format table as the previous year, of course) - into the workbook for this year’s query (since the query is doing the same things, step-wise) - and I am now able to test the query and make the necessary modifications (for example, if there is a issue specifically relating to the current year’s data) to the query within the Advanced Editor, in order to fix it.
I am not at the point yet, where I am able to make my queries dynamic - or where I am able to use lists, records or data types. It would be nice to be able to use those - but as I said, for the purposes of what I am using Power Query for, my knowledge is sufficient. But there is always room for improvement. It is only a matter of whether I have the time to study it.

[mattschoular]

Thanks Chandeep. Power Query is awesome. I use it all the time.

[mirrrvelll]

Because it is Number format and you did a Text fx. And this info about M Course - finally! =))))

[juanpaoloyt]

Leila Gharani is for Excel and VBA as Goodly is for Power Query.

[pukrewl]

Thank you for video. Course about M language - awesome idea. Looking forward to seeing it.

[sanumpzha]

Another interesting and informative video.👍Chandeep.

[GosCee]

Thanks for this, sir. It helps tremendously. The code returned an error because the data types did not match.

[ALex-fpzx]

Thanks Goodly, nice vlog. You are the best in case of M-code and DAX.
(and about the Error - the formula works with string not digits)

[markhenderson]

I watch all of your content. This is one of your best. Keep up the good work!

[baroute]

Hey Chandeep,
Again, I would like to thank you for all these videos, I’m completely fan and use Power Query all the time.
Is there a way in you M language course, to have multiple examples with List.Generate and List.Accumulate functions ? Because I think I’m doing steps that are not necessary and these functions could help but it’s a little bit tricky to understand yet 😊

[garylhaas]

learning the vocabulary about a language is important. if you don't know the vocabulary, it is difficult to ask questions and have conversations.