Completed
44. List to expand rows from improper data set with a range of years in cells
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Master Power Query M Code and Data Shaping for Data Analysis
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Why M Code?
- 3 3. Files to download and follow along
- 4 4. Power Query Editor
- 5 5. 3 Places to edit M Code
- 6 6. Introduction to let expression
- 7 7. Define Expressions
- 8 8. Introduction to the 15 M Code Values
- 9 9. Data Types, Type value
- 10 10. Operations and Data Types
- 11 11. identify Expressions in a let expressions
- 12 12. Change Data Type
- 13 13. Group By and Table.Group function, first example. Why list within a list is so useful!
- 14 14. Identifiers in M Code and why you never use spaces
- 15 15. Hack Group By dialog box to make calculations not in dialog box
- 16 16. Keywords
- 17 17. Editing in Advanced Editor, including Shift + Enter
- 18 18. Syntax for let expression
- 19 19. All 15 M Code Values and Operators that are allowed for each M Code Value
- 20 20. Null value
- 21 21. Logical value and formulas
- 22 22. Text value and formulas
- 23 23. Number value and formulas
- 24 24. Why it is important to use value type and not data type for determining whether an operation is valid.
- 25 25. Relationship between Values and Data Types
- 26 26. Colaesce operator or if expression when you have null values?
- 27 27. Custom Column and Table.AddColumn function
- 28 28. Time value and formulas
- 29 29. Date value and formulas
- 30 30. Date.AddDays function
- 31 31. Duration value
- 32 32. Duration.Days function
- 33 33. Power Query Dates 1/1/0001 to 12/31/999 and how they Rule: many examples!!!
- 34 34. Calculate hours worked through midnight. This is basis for custom function later in video
- 35 35. Number.Round function vs. ROUNDDOWN vs. INT
- 36 36. let expression to define variables in formulas
- 37 37. Convert ISO Dates to serial number dates
- 38 38. Using Locale feature: Convert dates and numbers from one locale France to another United Sates
- 39 39. Duration.Days vs. Duration.TotalDays functions
- 40 40. Datetime value and Datetimezone value
- 41 41. Table, list, record values can hold more than one M Code value
- 42 42. List value and formulas
- 43 43. Aggregate functions require lists
- 44 44. List to expand rows from improper data set with a range of years in cells
- 45 45. Record value and formulas
- 46 46. Generalized Identifiers
- 47 47. Table value and formulas
- 48 48. Binary value
- 49 49. M Code lookup
- 50 50. Row Index Lookup examples
- 51 51. Key Match Lookup examples
- 52 52. Excel.CurrectWorkbook function
- 53 53. Primary Keys and lookup
- 54 54. Lookup columns for aggregate functions
- 55 55. Merge feature and Join Operations: Left Outer, Inner, and Left-Anti
- 56 56. Function value: custom functions
- 57 57. Hours worked custom function
- 58 58. On Premine folder and file paths and Data Connections dialog box
- 59 59. Fix and Append Text Files custom function
- 60 60. Append tables with Table.ExpandColumns function
- 61 61. Append tables with Table.Combine function
- 62 62. each and underscore explained!
- 63 63. Approximate Match custom function
- 64 64. Table.Group function fourth argument: GroupKind
- 65 65. Table.Group function fifth argument: Comparer as function
- 66 66. Summary
- 67 67. Conclusion
