PowerQuery M code explanation (for Excel newcomers)

[@avvabaldur]

This is one of the best explanations of M Language i've seen so far ! All the best!

[@kebincui]

Very good tutorial. Please do more for basic stuff like this which helps to understand its work mechanism. 👍🌹

[@tanteckleng3665]

Excellent videos Making complex concepts simple to understand.

[@wayneedmondson1065]

Aweseome video! I really like the topics you choose and have learned a lot from your channel. Keep up the great work! Thumbs up!!

[@eziola]

These videos are great! Keep them coming! Question for you. . . Have you ever combined the Table.TransformColumns function with your own custom function to modify a column of data? If so, what is your most common use of this? I think it's one of the most powerful things you can do in Power Query. Creating your own custom function for a specific purpose and using it with Table.TransformColumns to modify table data. Second question. . . What's your most-used technique for looking up data in Power Query (similar to Excel VLOOKUP)?

[@ExceedLearning]

Thank you! As for the questions, yes I have used Table.TransformColumns with custom functions, but I still find it limited since you can reference only a single column when using custom function (when you transform a column, you can only access that column by using _ , you cannot access other columns from the table). The most used technique similar to vlookup is the merge queries option (using left outer join).

[@michaelmaynard9166]

We probably didn’t need the 5 minutes of SUM explanation if we’re here

[@zahoorsarbandi2982]

a very nice video.. please keep it up!

[@Paladin101]

@3:15 it states “Scholars lists or records but as an”… What is “Scholars”? I note the when you mention it at other points in comes up with alternatives such as ‘colors’. Can you clarify please?

[@ExceedLearning]

Scalar, like a single value.

[@Paladin101]

@@ExceedLearning Thanks. I couldn’t work it out simply because I was unfamiliar with the term 👍

[@danielnichols3594]

This seems slightly misleading. Yes, the Power Query mashup engine is much better than using the Excel function language to perform the same data transformations. You're not going to use Power Query to perform the SUM function. Rather you'd be using DAX (Data Analysis Expressions) to perform the sum using SUM or SUMX. And that's processed by the SSAS analytical database engine more than the Power Query mashup engine. I find learning M code (bypassing the PQ user interface) to be a real challenge.

[@rashidkhan8161]

hi there, Could please help me to solve this, I have simple list Source = {a, b ,c , d}, when I use this List.Transform( Source, each [_=List.PositionOf(Source, _)]) it create list of record but every record showing filed name "_" , _=0, _=1 etc.. instead of A=0, B=1 etc..

[@ExceedLearning]

Hi Rashid, The solution could be to rename the record field called "_". Try using this: = List.Transform( Source, each Record.RenameFields([_=List.PositionOf(Source, _)], {"_", _})) By using Record.RenameFields, you take the field named "_" from the record, and rename it with current row in the list.