![]() M code is the language behind the scenes of power query. The M stands for data Mash-up, as power query is all about connecting to various different data sources and “Mashing” them up. This post will introduce you to the basics of the power query M code language and will assume you already know the basics of power query. Many transformation steps can be easily performed from the power query editor ribbon and you don’t need to know any code to clean and shape your data.īehind the scenes of the user friendly editor, Excel is translating each step in your transformation process from those ribbon commands into the power query M code language. It’s very powerful and also very easy to use and the query editor has a super intuitive user interface for an Excel user. It can be found in the Data tab in the Get & Transform Data section of the ribbon. ![]() Power Query is a very powerful data extraction and transformation tool that comes baked into Excel 2016 (or later), Excel for Office 365, and Power BI.
0 Comments
Leave a Reply. |