PowerQuery M code explanation (for Excel newcomers)

Рет қаралды 3,840

Жыл бұрын

In this video we will show the similarities between Excel and M formula language! They are both functional languages with a few important differences.
👉Need more assistance? Check our website at exceed.hr/en/services/
#PowerBI #M #Excel

Пікірлер: 14

@avvabaldur 2 ай бұрын

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

@tanteckleng3665 7 ай бұрын

Excellent videos Making complex concepts simple to understand.

@kebincui Жыл бұрын

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

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

@zahoorsarbandi2982 Жыл бұрын

a very nice video.. please keep it 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).

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

@michaelmaynard9166 Жыл бұрын

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

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