Releases: naveenjujaray/M-Query-Cheat-Sheet
MQueryCheatSheet v1.0.1
📦 Power Query / M Query Cheatsheet — Release v1.0.1
Author: Naveen Jujaray
Version : v1.0.1
Created On: 20-Aug-2025
Last Updated: 20-Aug-2025
Reference Links:
📄 PDF Version
🌐 Microsoft Learn Docs
🚀 What's Included
This release introduces a comprehensive cheatsheet for Power Query M language, designed for quick lookup and learning. It includes:
- ✅ Syntax and examples for 200+ M functions
- 📚 Categorized sections for:
- Table, Text, Number, Date, Time, DateTime, Duration functions
- Logical & Conditional, List, Record, Uri, Binary, and Metadata functions
- Advanced topics like Expression Evaluation, Diagnostics, and Accessing Data
- 🧠 Best practices and production-readiness tips
⚠️ Warnings on deprecated or preview-only features
📘 Highlights
🧮 Table Functions
Table.AddColumn,Table.AddConditionalColumn,Table.AddIndexColumnTable.Buffer,Table.Combine,Table.Group,Table.Join,Table.Pivot,Table.Unpivot
🔤 Text Functions
Text.Upper,Text.Trim,Text.Replace,Text.Split,Text.Combine,Text.Format
🔢 Number Functions
Number.Abs,Number.Power,Number.Round,Number.Mod,Number.RandomBetween
📅 Date & Time Functions
Date.Year,Date.Month,Date.AddDays,Date.IsInCurrentMonthTime.Hour,DateTime.LocalNow,DateTimeZone.SwitchZone
🧪 Logical & Conditional
if...then...else,try...otherwise,Value.Equals,Value.Is,List.AnyTrue
🧰 Advanced & Metadata
Expression.Evaluate,Value.Metadata,Diagnostics.Trace,Error.Raise
🛡️ Production Usage Tips
- ✅ Always verify function signatures in official docs
- 🧪 Test with your target engine (Power BI, Excel, Dataflows, etc.)
- 🌍 Use explicit types and culture parameters
- 🔔 Watch for deprecation and breaking changes
📌 Disclaimer
This cheatsheet is community-compiled. Use at your own risk.
No warranty of completeness or correctness is provided.
Always follow Microsoft Learn and your organization’s governance policies.
MQueryCheatSheet v1.0.0
📦 Power Query / M Query Cheatsheet — Release v1.0.0
Author: Naveen Jujaray
Version : v1.0.0
Created On: 20-Aug-2025
Last Updated: 20-Aug-2025
Reference Links:
📄 PDF Version
🌐 Microsoft Learn Docs
🚀 What's Included
This release introduces a comprehensive cheatsheet for Power Query M language, designed for quick lookup and learning. It includes:
- ✅ Syntax and examples for 200+ M functions
- 📚 Categorized sections for:
- Table, Text, Number, Date, Time, DateTime, Duration functions
- Logical & Conditional, List, Record, Uri, Binary, and Metadata functions
- Advanced topics like Expression Evaluation, Diagnostics, and Accessing Data
- 🧠 Best practices and production-readiness tips
⚠️ Warnings on deprecated or preview-only features
📘 Highlights
🧮 Table Functions
Table.AddColumn,Table.AddConditionalColumn,Table.AddIndexColumnTable.Buffer,Table.Combine,Table.Group,Table.Join,Table.Pivot,Table.Unpivot
🔤 Text Functions
Text.Upper,Text.Trim,Text.Replace,Text.Split,Text.Combine,Text.Format
🔢 Number Functions
Number.Abs,Number.Power,Number.Round,Number.Mod,Number.RandomBetween
📅 Date & Time Functions
Date.Year,Date.Month,Date.AddDays,Date.IsInCurrentMonthTime.Hour,DateTime.LocalNow,DateTimeZone.SwitchZone
🧪 Logical & Conditional
if...then...else,try...otherwise,Value.Equals,Value.Is,List.AnyTrue
🧰 Advanced & Metadata
Expression.Evaluate,Value.Metadata,Diagnostics.Trace,Error.Raise
🛡️ Production Usage Tips
- ✅ Always verify function signatures in official docs
- 🧪 Test with your target engine (Power BI, Excel, Dataflows, etc.)
- 🌍 Use explicit types and culture parameters
- 🔔 Watch for deprecation and breaking changes
📌 Disclaimer
This cheatsheet is community-compiled. Use at your own risk.
No warranty of completeness or correctness is provided.
Always follow Microsoft Learn and your organization’s governance policies.
🌐Full Changelog: here