Day 18 of #DataAnalystJourney
While studying Power Query today, I got introduced to something that runs behind every transformation I've been making: the M language.
Every time you clean, merge, or reshape data in Power Query, M code is being written automatically in the background.
The eye-opening part? You can open the Advanced Editor and read or even write that code directly.
Each transformation step is stored as a variable, building on the previous one. That's how Power Query remembers every action in sequence.
This means that for transformations the graphical interface can't handle, you can go straight into the script and do it manually.
I've been using Power Query for weeks without realizing there was a full scripting language powering it the whole time.
It's a reminder that the tools we use daily often have more depth than what's visible on the surface.
Have you ever written or modified M code directly in Power Query?
#DataAnalytics #PowerQuery #MLanguage #Excel #LearningInPublic
Day 17 of #DataAnalystJourney
While studying Power Query today, I finally understood the difference between Append and Merge — two operations that sound similar but serve completely different purposes.
Append stacks datasets with the same structure on top of each other. An example is combining 10 months of job postings from different sheets/tables into one clean table. While,
Merge joins two different datasets using a common column. Just like linking a salary table to a skills table using a shared Job ID Column.
What made this click for me was understanding the row counts before merging. One table had ~32,000 rows. The other had ~167,000.
Knowing that upfront helped me anticipate how different join types would affect the final output. Without that awareness, unexpected nulls or duplicate rows can quietly distort your analysis.
Data work isn't just about writing the right steps, it's about understanding what your data looks like before and after each transformation.
#DataAnalytics #PowerQuery #Excel #LearningInPublic #DataSkills
9
387
Feb 10
Sometimes you just need to see what your M (Power Query) code is actually doing — and that’s not always obvious.
I added an Execution Plan to M-Game: run your code, open the plan, inspect the flow intermediate results ✅
mgame.datameerkat.com/
#PowerQuery #MLanguage #PowerBI
1
9
622
Jan 30
I built an online practice app for M (Power Query) 🚀
✅ 150 levels across topics
✅ Multiple solutions per level
✅ No account, progress saved locally
✅ Most of the M functions are implemented
Try it: mgame.datameerkat.com
#PowerQuery #MLanguage #PowerBI
7
309
10 Jun 2025
🧠💻 M Language — Part II
linkedin.com/feed/update/urn…
Today we got hands-on with:
➕ Simple functions like:
(x, y) => x y
🔄 Conditional logic functions
🔤 Useful tricks like:
Text.Upper("abc") → "ABC"
Number.Round(2.75) → 3
Table.SelectRows(...) → filter magic ✨
💡 Tips we loved:
✅ Keep functions small
✅ Name your parameters clearly
✅ Test step by step
✅ Comment your work!
Data can be cool — especially when it speaks M 😎
#PowerQuery #MLanguage #DataTraining #PowerBI #LearningByDoing #DataIsFun #OmairAcademy
9 Jun 2025
هل سبق وسمعت عن لغة M في Power BI؟
كثير من المستخدمين يركّزون على DAX ويتجاهلون قوة M، رغم إنها الأساس في تنظيف وتحويل البيانات داخل Power Query.
في هذا الدرس (أو الفيديو)، ركّزت على:
🔹 تعريف مبسّط للغة M
🔹 متى ولماذا تحتاج تتعلمها
🔹 البنية الأساسية للكود (let / in)
🔹 أمثلة عملية مثل استيراد البيانات وتصفية الصفوف
🔹 ونصائح مهمة للمبتدئين
الهدف مو بس تكتب كود، بل تفهم كيف تُنفَّذ خطوات التنظيف والتجهيز بدقة وكفاءة.
📂 إذا كنت تبدأ رحلتك مع Power BI أو تبغى ترفع مستواك في التعامل مع البيانات، ففهم M Language بيفتح لك آفاق جديدة.
🎯 تابع الدرس من هنا:
linkedin.com/posts/alomairab…
وأخبرني في التعليقات: هل تستخدم M؟ أو تعتمد فقط على الواجهة الرسومية؟
3
14
5,343
5 Dec 2024
Imagine this - After hours of perfecting your query, someone accidentally messes it all up. 😞 I've been there, and it's not fun.
Don't let it happen to you use 'Protect Workbook' to safeguard your hard work!
I’d love to hear if you’ve had a similar experience. Share your stories below!
#PowerQuery #Excel #MLanguage #Goodly
1
1
33
1,623
29 Nov 2024
Melissa, Rick and I are sharing some of our favourite Power Query tricks—dynamic tables, advanced cleaning and more. Watch the video and let us know which trick you liked the most! 👊
#PowerQuery #MLanguage #DataAnalysis #Excel
2
17
93
4,202
2 Nov 2024
Imagine we have to write the MQuery or MLanguage in PowerQuery before we can clean Data instead of clicking 😂😂🤣
None of us will use Excel again
6
528
14 Oct 2024
Why are you using MY mlanguage without permissudion. Cultrual apprroppriation much???????.???
14 Oct 2024
Good morning
Buenos días
Bom Dia
Guten Morgen
おはよう
1
2
135
22 Jul 2024
1
2
30
22 May 2024
Struggling with #PowerQuery's M language syntax?
I've compiled a quick PDF guide to make your learning journey smoother. Swipe through the images in this thread to check it out! #DataAnalytics #PowerBI #MLanguage
1
11
59
4,580
26 Apr 2024
Minor updates to Data Mashup Explorer and Data Mashup Cmdlets released today:
Added some gracefulness when encountering certain unusually formatted files.
bengribaudo.com/tools/datama…
bengribaudo.com/tools/datama…
#PowerQuery #MLanguage
4
456
18 Mar 2024
Understand the functionality behind the Power Query Editor and get better in report development. ow.ly/Jg1u50QUZQv #data #decision #business #bigdata #nft #AI #MLT #ML #BI #analytics #dashboard #crypto #SME #startups #DAX #powerquery #Mlanguage #development #report #KPI
3
109
19 Jan 2024
Morning Quiz:
- Excel has Functions and Formulas
- Databases have SQL
- PowerQuery has MLanguage
What does PowerBI desktop have? 🤔🤔🫣
17
3
15
2,273
19 Jun 2023
Anyone want to work towards mastering #PowerQuery's #MLanguage next week? There is room for you to join us. :-)
12 May 2023
Another Mastering M class coming soon! Please join us and spread the word!
June 27–29 (live, web-based class)
Early registration discount available
bengribaudo.com/courses/mast…
#PowerQuery #MLanguage
ALT Class graphic/ad
2
4
776
12 May 2023
Another Mastering M class coming soon! Please join us and spread the word!
June 27–29 (live, web-based class)
Early registration discount available
bengribaudo.com/courses/mast…
#PowerQuery #MLanguage
ALT Class graphic/ad
5
16
5,483
17 Apr 2023
Anyone want to take a deep dive into #PowerQuery's #MLanguage this week?
There is room for you to join us!
bengribaudo.com/courses/meet…
ALT Mastering M class ad graphic
1
13
2,542
22 Mar 2023
1/ Hey #PowerBI users! Are you confused about the difference between DAX and M language? Both are used in Power BI, but they serve different purposes. Let's break it down. #DAX #Mlanguage
3
2
8
465
7 Mar 2023
How well do you understand M's laziness, streaming & immutability?
#MLanguage #PowerQuery #PowerBI #Excel
bengribaudo.com/blog/2023/03…
1
1
3
502
7 Mar 2023
#MLanguage specification updated to reflect try's catch
#PowerQuery #PowerBI #Excel
("catch" was added to M last spring [see powerquery.microsoft.com/en-…] but the spec wasn't updated to reflect its addition at that time.)
github.com/MicrosoftDocs/que…
2
591
16 Feb 2023
Value.ReplaceType & Table Column Renames (Bug Warning!)
If you work in the advanced realm of ascribing types, there are a couple interesting behaviors to be aware of related to column renames (including a bug!).
#PowerQuery #MLanguage #PowerBI #Excel
bengribaudo.com/blog/2023/02…
ALT Screenshot showing mismatch between column used in Table.SelectRows filter and query's output
5
6
2,429