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.AddIndexColumn
• Table.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.IsInCurrentMonth
• Time.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.