Uploaded February 2026 | Updated September 2026, 1 week ago
Quick Measures can create YTD for you in seconds.
Pick your value, select the date column, click Done. That’s it.
===== 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!
Quick Measures can create YTD for you in seconds.
Pick your value, select the date column, click Done. That’s it.
===== 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 Lazy Way to Write Power Query Code 🥱
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 -
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! The Lazy Way to Write Power Query Code 🥱](https://i.ytimg.com/vi/Vz3qgA0VK0g/mqdefault.jpg)



![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)





