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-M365ExcelClassVideoFiles.zip
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: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
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/by/4.0/ . 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
Видео Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12 канала ExcelIsFun
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: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
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/by/4.0/ . 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
Видео Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12 канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big DataIntroduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, RatioSpilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different CountriesMSPTDA 08.5: Power Query Group By Unique List or Consecutive OccurrencesMSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to ExcelMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeOffice 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/ConditionsHighline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.E-DAB 01: What is Data Analysis & Business Intelligence?E-DAB 09: Power BI Desktop: Data Modeling & Interactive VisualizationsHighline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUPMicrosoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain VariablesE-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards