Video: M Language Tips for achieve more with Power Query
Van: Celia Alves - Solve & Excel
Duur: 28:39
Vind de waarde in 1 cel van een tabel, spring in de Query naar een vorige stap, zoek de 1e datum van de actuele maand, dynamisch verwijderen van kolommen en aanpassingen in de Geavanceerde Editor
The tools offered by Power Query Editor are enough to solve most problems related to Data importation and transformation (ETL). However, some business cases present challenges that are solved faster and better if we are able to make slight amendments to the M Code that Power Query generates for us through the buttons we click in the user interface. We will look at some practical examples of very helpful M code snippets in Power Query in Excel. Chapters: 0:08 – Introduction 01:37 - What is the M language and how to access the code 02:09 - Learning Resources for M Language 03:57 - Example 1: Getting the value of one cell in Power Query (Table, Column, Row, Cell) 12:52 - Example 2: Getting Data from the first day of the current month onwards 19:15 - Example 3: Dynamic Column List 28:13 – Conclusion
Functies: #date(), DateTime.LocalNow(), DateTime.Date(), Date.Month(), Date.Year(), List.LastN()
