Uploaded May 2026 | Updated September 2026, 1 week ago

---

Power Query has a small keyword called is, and it can be really helpful when you are working with messy or mixed data.

With the is keyword, you can quickly check whether a value is a number, text, list, table, record, or another type of object.

For example, you can write:

[Column] is number

And Power Query will return TRUE or FALSE depending on whether the value is actually a number.

This becomes useful when a column has different types of values, or when you want to check something before applying the next step in your query.

In this video, I’ll show you how the is keyword works in Power Query and how you can use it to make your queries more reliable.

You’ll learn:

- How the is keyword works in M
- How to check if a value is a number, text, list, or table
- How to use TRUE/FALSE checks in Power Query
- Why this is useful when working with mixed or messy data

A very small keyword, but definitely worth knowing if you work with Power Query.



===== 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!