Getting Started with Power Query M Language in Excel
This article introduces M language concepts and examples of using M to manipulate data in Excel.
2023-10-02
M Langauge
Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
2021-03-03
Converting and Formatting Numbers Using the M Language
Power BI designer is based upon the Power Query formula language informally known as "M". Unfortunately, the advanced editor inside the Power BI designer does not support syntax highlighting, meaning it can be easy to make mistakes. Matt Mason shows how you can extend the Notepad++ editor to support this feature.
2015-12-03
3,200 reads
Simple Mathematical Formulas using the M Language
The Power BI desktop designer is a great tool; however, the hardest part of any Business Intelligence project is gathering and formatting the data into reportable datasets. John Miner explains how having a deeper understanding of the M language will help a BI developer in cases where the menus can not.
2015-10-27
2,906 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
restore db as db_copy. resolve hardcoded references within procedures to db.
So I backup & restore db as db_copy. within both there is a proc...
Transpose sql table rows into columns
I want to transpose sql table rows to columns. I have written a query...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers