• views: 68
• date: 13 September 2024
• posted by: voska89

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

https://www.udemy.com/course/power-query-m-language-basics/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.