Uploaded November 2025 | Updated September 2026, 1 week ago
Stop typing quotes and brackets manually. In Power Query, just select text and press Shift + " to instantly wrap it. Works for {} and [] too.
===== 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!
Stop typing quotes and brackets manually. In Power Query, just select text and press Shift + " to instantly wrap it. Works for {} and [] too.
===== 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!



![This #PowerQuery Trick Helps You Catch Weird Data
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 -
https://products.goodly.co.in/power-query-book/
βοΈ Master M in Power Query -
https://products.goodly.co.in/learn-m-powerquery/?
βοΈ Mastering DAX in Power BI -
https://products.goodly.co.in/learn-dax-powerbi/
βοΈ Power Query Course -
https://products.goodly.co.in/learn-power-query/
βοΈ Master Excel Step-by-Step-
https://products.goodly.co.in/learn-excel/
LINKS π
Blog π° - https://www.goodly.co.in/blog/
Corporate Training π¨βπ« - https://www.goodly.co.in/training/
Need my help on a Project π»- https://www.goodly.co.in/consulting/
CONTACT π
Twitter - https://twitter.com/chandeep2786
LinkedIn - https://www.linkedin.com/in/chandeepchhabra/
Email - goodly.wordpress@gmail.com
WHO AM I?
A lot of people think that my name is Goodly, its 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, youll find a ton of interesting videos that I have created :) Cheers! This #PowerQuery Trick Helps You Catch Weird Data](https://i.ytimg.com/vi/X3Lg28cQKFY/mqdefault.jpg)






