Power Query M Language Basics
Power Query M Language Basics
Published 9/2024
Created by Joshua Day
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 8 Lectures ( 57m ) | Size: 286 MB
Everything You Need to Know to Understand How to Create and Modify List, Records, Tables, and each _ Formulas and More!
What you'll learn:
Power Query M language 101
Lists, Records, Tables
each _
if, then, else, try, otherwise, and let expressions
Requirements:
Basic knowledge of Excel
Description:
Most courses covering power query focus on navigating menus in the graphical user interface and recording steps by pushing the available buttons. Although that is a quick way to get started in power query, knowing the fundamentals that will be covered in this course will help you better understand what those functions are doing and how they work, and then you will be able to create and modify the code in the queries to be more powerful and efficient than what could otherwise be achieved.Throughout this course the following topics will be coveredM language 101ListsRecordsTableseach _ and the Lambda function using =>if then else expressionstry otherwise expressionslet expressionsM Language 101 Topics:BackgroundGeneral OrientationDelimiters and OperatorsPrimitive valuesCase SensitivityZero-based IndexSpaces and line breaksMisc. Tips and TricksLists in M Language TopicsHow Used in Power QuerySyntaxLists of ListsCombining ListsGetting Data from ListsSample List FunctionsReferencing Lists from Other Query StepsRecords in M Language TopicsHow Used in Power QuerySyntaxLists of RecordsCombining RecordsGetting Data from RecordsSample Record FunctionsTables in M Language TopicsHow Used in Power QuerySyntax (#table, TableFromColumns, TableFromRows, TableFromRecords)Combining TablesGetting Data from TablesSample Table FunctionsBlank Table Syntaxeach _ and (x) =˃ (lambda function)Lambda Functions using =>each _ vs (x)=> xeach _ Used in TableAddColumneach _ Used in TableGroupeach _ Used in TableGroupeach _ Used in TableTransformColumnseach _ Used in TablePivoteach without _Direct Argument Notationif then else try otherwiselet expressions
Who this course is for:
Anyone who wants to quickly get familiar with the basics of Power Query M Language to understand how the code generated by the recorded steps work.
https://rapidgator.net/file/3f1e92cedb45e6b1372986471bb369ed/Power_Query_M_Language_Basics.rar.html
