The ultimate M code trick for calculated columns #powerquery #microsoftexcel #tutorial @GoodlyChandeep
The ultimate M code trick for calculated columns #powerquery #microsoftexcel #tutorial  @GoodlyChandeep
Uploaded May 2026 | Updated November 2026, 2 days ago
In Power Query, you don’t always need to create custom columns one by one.

In this video, I’ll show you a simple M trick using records to create multiple calculated columns in a single step.

We’ll take a basic sales table and create:

- Sales value using Units × Price
- Commission using 10% of Sales

Instead of adding one custom column for Sales and another for Commission, we’ll define both calculations inside a record, expand it, and get both columns together.

This is especially useful when you need to create 3, 4, 5 or more calculated columns in Power Query and want to keep your steps cleaner.


===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
The ultimate M code trick for calculated columns #powerquery #microsoftexcel #tutorialUse Power Query Better Than 99% Of PeopleHow to Calculate Financial Quarter in ExcelSeparate Text and Numbers from Random Text in Power QuerySimple Power Query Trick to remove both Nulls and Blanks togetherStop Filling Blank Cells ManuallyThe Power BI Mistake Everyone Makes OnceThe Only SVG in Power BI Video You NeedThis Free Tool Cleans Up Your Power BI Model InstantlyEveryone Sucks at Power BI until They Learn This!Excel Gets This Date Calculation WrongThe Most Powerful Free Tool Inside Excel
Goodly |

The ultimate M code trick for calculated columns #powerquery #microsoftexcel #tutorial

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER