M Query Fundamentals

The M language is used to access and transform data in Power BI, Excel 2016, SQL Server Analysis Services 2017, and other Microsoft products. Although these tools provide graphical interfaces for common query operations, more robust data retrieval and integration solutions require an understanding of the M language. In this session we first review core concepts of the M functional language including expressions, values, functions, and query folding. We then walk through common examples of using M as a data access layer for data models and implementing transformations such as data type changes, joins, derived columns, conditional logic, and more.