Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi @JimJim
The M language, also known as the Power Query M formula language, is a powerful and functional language used in Power BI and Power Query to manipulate data. It is case-sensitive and shares similarities with F# in terms of functionality12.
Here are some key points about the M language:
Functional Language: M is a functional language, which means it focuses on the declaration and composition of functions to transform data.
Data Mashup: It is primarily used for data mashup, which involves filtering, combining, and transforming data from one or more supported data sources1.
Power Query Editor: In Power BI, the M language is supported only within the Power Query Editor, which is the tool used for data transformation and preparation2.
Wide Application: M language is embedded in various Microsoft products, including Excel, Power BI, Analysis Services, and Dataverse, enabling repeatable data mashups3.
Rich Function Library: The M language features nearly 1000 unique functions that can be used to perform a wide range of data manipulation tasks4.
The M language is integral to Power BI and Power Query as it provides the underlying code that runs the data transformation processes. When you use the graphical interface of Power Query to perform tasks like filtering, sorting, or merging tables, M code is generated in the background. This code can be viewed, edited, and written manually to create more customized and complex data transformation processes.
Check this link:
https://learn.microsoft.com/en-us/powerquery-m/m-spec-introduction
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @JimJim
The M language, also known as the Power Query M formula language, is a powerful and functional language used in Power BI and Power Query to manipulate data. It is case-sensitive and shares similarities with F# in terms of functionality12.
Here are some key points about the M language:
Functional Language: M is a functional language, which means it focuses on the declaration and composition of functions to transform data.
Data Mashup: It is primarily used for data mashup, which involves filtering, combining, and transforming data from one or more supported data sources1.
Power Query Editor: In Power BI, the M language is supported only within the Power Query Editor, which is the tool used for data transformation and preparation2.
Wide Application: M language is embedded in various Microsoft products, including Excel, Power BI, Analysis Services, and Dataverse, enabling repeatable data mashups3.
Rich Function Library: The M language features nearly 1000 unique functions that can be used to perform a wide range of data manipulation tasks4.
The M language is integral to Power BI and Power Query as it provides the underlying code that runs the data transformation processes. When you use the graphical interface of Power Query to perform tasks like filtering, sorting, or merging tables, M code is generated in the background. This code can be viewed, edited, and written manually to create more customized and complex data transformation processes.
Check this link:
https://learn.microsoft.com/en-us/powerquery-m/m-spec-introduction
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @VahidDM , thank you for this wonderful explanation, but it wasn't me who asked the question 🙃
Oh sorry
but the id is same as you!
regards
vahid
Hi @Syndicate_Admin ,
you may refer this link to get overview of Mash Langauge.
https://learn.microsoft.com/en-us/powerquery-m/quick-tour-of-the-power-query-m-formula-language
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |