M Programming Language: Introduction

Power Query and Power BI are powerful tools that allow you to aggregate a wide variety of data sources and transform them into clean workable datasets. Behind the scenes, these two tools leverage the M Formula Language to provide quick and easy transformations through a wide variety of built-in functions. In this video, we introduce our new programming language and get some context about what it is and how it works.

Video Resources:
--------------------------------------------------
Resource: GitHub File

Resources:
--------------------------------------------------

Support Sigma Coding:
--------------------------------------------------

Related Topics:
--------------------------------------------------
Title: M Programming Language Tutorial: Records

Title: M Programming Language: Working with Data Sources

Title: M Programming Language: Fundamentals

Title: M Programming Language: Introduction

**Amazon Associates Disclosure:
--------------------------------------------------

Tags:
--------------------------------------------------
#Mlanguage #PowerQuery #Introduction

[sandymaverick]

Awesome :) Love from India. I was looking a comprehensive tutorial on M language, it appears my search ends here. I will go through the entire library, and tell how it goes.

[markosverdhi]

I didnt know that this language existed until messing with Power query editor for my job. Fast forward a week, and I'm writing scripts in this random language built directly into power query which, in itself, is built into excel... So overengineered. I love it

[granand]

How can I become expert in M language to manipulate data, fuzzy logic, etc when I have office 16 excel

[GGoblin]

Hey thanks for this breakdown. I was wondering, I am using the M language in a pollingexpression for a customized refresh policy using TMSL script in MSS (microsoft sql server management studio) . This instance in MSS is a powerbi xmla endpoint. Now what I was wondering, I will need to compare the amount of rows or such to see if there are changes between the azure sql database and the powerbi dataset which is linked in MSS. The refresh itself will be triggered on API call with logic apps so this is not an issue. The issue is to flag the partitions to do a full refresh on the partition that has more rows or is not conisistent with the powerbi dataset. Is this possible? thank you in advance!

[AlbrechtJ]

Thanks for this brilliant series on M Language. Currently in Aug 2022, this playlist is #1 on this topic. No competitor.

[steve_fossey]

Really good overview, thanks a lot. What I'd really like to do is use this engine to send a multi-statement query to SQL server from VBA. With the macro editor I can see that this uses mashup. Using ADO I cannot send a declare statement, and apparently mashup can. I'd love to understand how to manipulate the output as an array, if it is one.