Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

Описание: Download Zipped Folder with All Files: https://excelisfun.net/files/12-M365E...

This video is a comprehensive lesson in Power Query M Code in Excel & Power BI.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here:    • Excel 365 & Power BI Intermediate to Advan...  

This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We use a Group By Query to learn about the basics of M Code.
7. (10:23) M Code Identifiers and spaces.
8. (14:21) let expression definition and structure.
9. (16:32) Expressions
10. (18:20) Insert or Delete Query (let expression) Steps: 2 possibilities.
11. (24:45) #shared to show Standard Library in Power Query
12. (26:32) Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type
13. (33:15) IF function and AND Function in M Code
14. (36:23) Compare Excel Close & Load to Power BI Desktop Close & Apply
15. (38:45) Copy and Paste Tables into Power BI Desktop.
16. (39:35) Power Query Date and Duration Examples
17. (46:32) Table Values
18. (51:08) Record Values
19. (53:37) List Values
20. (59:05) Binary, Function and Type M Code Values
21. (59:40) Data Types
22. (59:40) Values Vs. Data Types
23. (01:01:38) M Code Lookup: Two-way Lookup, Column Lookup, Row (or Record) lookup. Also know as: Projection (lookup column) and Selection (lookup row)
24. (01:03:19) Diagrams for M Code Lookup
25. (01:06:04) Row Index Lookup
26. (01:07:15) Key Match Lookup
27. (01:08:55) Drill Down, Primary Keys and Lookup
28. (01:13:33) Custom Functions (5 examples to learn basics)
29. (01:17:50) Build reusable function.
30. (01:22:08) Build Custom Function as a Query Step.
31. (01:27:04) each and Underscore.
32. (01:29:47) Approximate Match Lookup M Code Custom Function (4 examples)
33. (01:39:13) Full Video Summary and Conclusions
34. (01:40:32) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/... . Artist: http://audionautix.com/

#Girvin
#excelisfun
#M365
#MECS
#Microsoft
#MCode
#PowerQuery
#PowerBI
#DataMashup
#LearnMCode
#FreeMCodeClass
#LearnMCodeFast
#MCodeMadeEasy
#MCodeLanguage
#CustomFunctions
#MCodeCustomFunctions
#PowerQueryLookup
#MCodeLookup
#MCodeSpecifications
#datascience
#PowerQueryMCode
#DataAnalysis
#MicrosoftDataAnalytics
#PowerQueryMCode
#PowerBIMCode
#McodeAndDAX
#datacleaning
#datatransformation
#ETL
#advancedexcel
#mcode
#powerbi
#excel
#businessintelligence
#businessanalystcourse
#mcodetutorial
#mlanguage
#mlanguagetutorial
#powerbitutorial
#powerquerytutorial