Microsoft Power Query provides a powerful data import experience that encompasses many features.

Power Query works with Analysis Services, Excel and Power BI workbooks. A core capability of Power Query is to filter and combine data from one or more of a rich collection of supported data sources. Any such data mashup is expressed using the Power Query M Formula Language. It’s a functional, case sensitive language similar to F#.

Join Phoenix and Simpson Associates on Wednesday 20 January at 10am, where we will take you through Power Query and the language behind it – M. We will talk about its structure and syntax and why it’s useful to know and when to use it instead of Data Analysis Expressions (DAX). He will then go through an example of how to create a table from scratch using nothing but M.

Register Now

This is part of an ongoing Microsoft Power BI webinar series, so please check out the other sessions that we have coming up – Unlock the Potential of Your Data with Microsoft Power BI Webinar Series.

If you want to take the conversation further, Simpson Associates run a monthly Data Analytics Forum. Their Data Analytics Forum is a great platform to get together and facilitate discussions around shared challenges and experiences in everything data related. Simpsons take the lead from the members of the forum as to what they’d like to focus discussions around each month to provide you with a useful support mechanism in your day to day role. Learn more here.