Uploaded May 2026 | Updated September 2026, 1 week 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!