#PowerQuery's fill down ⬇️ /fill up ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may be an un-fill command coming to the UI in #PowerBI, but it's going to be some time before we see it in #Excel. Here's my trick to do it: www.youtube.com/watch?v=yHwt...
How to unfill in Power Query - Monkey Shorts Episode 047
Power Query's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the Power Query user interface, but that…
www.youtube.com
October 9, 2026 at 5:42 PM
#PowerQuery's fill down ⬇️ /fill up ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may be an un-fill command coming to the UI in #PowerBI, but it's going to be some time before we see it in #Excel. Here's my trick to do it: www.youtube.com/watch?v=yHwt...
#PowerQuery's fill down ⬇️ /fill up ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may be an un-fill command coming to #PowerBI, but it's going to be some time before we see it in #Excel. Here's @excelguru.ca's method: www.youtube.com/watch?v=yHwt...
How to unfill in Power Query - Monkey Shorts Episode 047
Power Query's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the Power Query user interface, but that…
www.youtube.com
October 8, 2026 at 5:17 PM
#PowerQuery's fill down ⬇️ /fill up ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may be an un-fill command coming to #PowerBI, but it's going to be some time before we see it in #Excel. Here's @excelguru.ca's method: www.youtube.com/watch?v=yHwt...
In this video, I show why #PowerQuery's Refresh All is not always the best choice when working with multiple queries in #Excel. 🔄
See how refreshing everything at once can accidentally wipe out manually classified data — and why some workbooks need a staged refresh process:
See how refreshing everything at once can accidentally wipe out manually classified data — and why some workbooks need a staged refresh process:
Stop Using Refresh All: Refresh a Single Table!
In this video, Ken shows why Refresh All is not always the best choice when working with multiple Power Queries in Excel.
Using a practical credit card transaction example, you’ll see how refreshing…
youtu.be
June 1, 2026 at 4:45 PM
In this video, I show why #PowerQuery's Refresh All is not always the best choice when working with multiple queries in #Excel. 🔄
See how refreshing everything at once can accidentally wipe out manually classified data — and why some workbooks need a staged refresh process:
See how refreshing everything at once can accidentally wipe out manually classified data — and why some workbooks need a staged refresh process:
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when writing a query. 📖 Maybe you need to discover a function, or maybe you just need more information on how it works. Here, we'll look at 2 options: www.youtube.com/watch?v=GX5z...
#Excel #PowerBI
#Excel #PowerBI
Accessing Power Query Documentation 1 - Monkey Shorts Episode 027
Sometimes, you want to browse Microsoft's official documentation for Power Query's function library when you are writing a query. Maybe you need to discover a function, or maybe you just need more…
www.youtube.com
May 22, 2026 at 4:10 PM
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when writing a query. 📖 Maybe you need to discover a function, or maybe you just need more information on how it works. Here, we'll look at 2 options: www.youtube.com/watch?v=GX5z...
#Excel #PowerBI
#Excel #PowerBI
In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
www.youtube.com
December 19, 2025 at 5:30 PM
In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#PowerQuery's fill ⬇️/fill ⬆️ feature is amazing but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! In this episode of Monkey Shorts, I'll show you how: www.youtube.com/watch?v=yHwt...
#Excel #PowerBI
#Excel #PowerBI
How to unfill in Power Query - Monkey Shorts Episode 047
Power Query's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the Power Query user interface, but that…
www.youtube.com
October 24, 2025 at 4:11 PM
#PowerQuery's fill ⬇️/fill ⬆️ feature is amazing but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! In this episode of Monkey Shorts, I'll show you how: www.youtube.com/watch?v=yHwt...
#Excel #PowerBI
#Excel #PowerBI
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. In this Monkey Shorts, we'll look at 2 ways to do this:
➡️ Microsoft's official website
➡️ Using the #shared keyword inside the Power Query editor
➡️ Microsoft's official website
➡️ Using the #shared keyword inside the Power Query editor
Accessing Power Query Documentation 1 - Monkey Shorts Episode 027
Sometimes, you want to browse Microsoft's official documentation for Power Query's function library when you are writing a query. Maybe you need to discover ...
www.youtube.com
June 6, 2025 at 5:20 PM
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. In this Monkey Shorts, we'll look at 2 ways to do this:
➡️ Microsoft's official website
➡️ Using the #shared keyword inside the Power Query editor
➡️ Microsoft's official website
➡️ Using the #shared keyword inside the Power Query editor
When writing in #PowerQuery's formula bar in #Excel or #PowerBI, you might see helpful tooltip text that indicates that there are 1 of x arguments for the function... But when you try to click on item 2 of x, it disappears! 😡 See how you can navigate through this shy little window:
Using Power Query Intellisense 2 - Monkey Shorts Episode 026
When writing formulas in the Power Query formula bar, you'll occasionally see helpful tooltip text that indicates that there are 1 of x arguments for the fun...
www.youtube.com
May 30, 2025 at 4:32 PM
When writing in #PowerQuery's formula bar in #Excel or #PowerBI, you might see helpful tooltip text that indicates that there are 1 of x arguments for the function... But when you try to click on item 2 of x, it disappears! 😡 See how you can navigate through this shy little window:
About an hour and a half to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Join us at 9am PST to discover how to go beyond #PowerQuery’s user interface and unlock advanced techniques to handle complex data challenges with Chandeep Chhabra. RSVP here: www.meetup.com/vancouver-po...
Power Query Tips and Tricks Beyond the User Interface | Chandeep Chhabra, Thu, Feb 13, 2025, 11:00 AM | Meetup
**SESSION TRACK:**
Excel & Power BI
**SESSION OUTLINE:**
Discover how to go beyond Power Query’s user interface and unlock advanced techniques to handle complex data chall
www.meetup.com
February 13, 2025 at 5:28 PM
About an hour and a half to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Join us at 9am PST to discover how to go beyond #PowerQuery’s user interface and unlock advanced techniques to handle complex data challenges with Chandeep Chhabra. RSVP here: www.meetup.com/vancouver-po...
In this Monkey Shorts episode, I show how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use. Watch on YouTube: https://buff.ly/4fHhaMD
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
buff.ly
January 3, 2025 at 5:23 PM
In this Monkey Shorts episode, I show how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use. Watch on YouTube: https://buff.ly/4fHhaMD
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
#PowerQuery's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! I'll show you how we can make this magic happen: https://buff.ly/3YAjj6h
#Excel #PowerBI
#Excel #PowerBI
How to unfill in Power Query - Monkey Shorts Episode 047
Power Query's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in th...
buff.ly
November 9, 2024 at 5:41 AM
#PowerQuery's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! I'll show you how we can make this magic happen: https://buff.ly/3YAjj6h
#Excel #PowerBI
#Excel #PowerBI
A while ago, I asked a co-worker how many ways he knew of to round a number. His answer was 1: if it ends in .4, round ⬇️ ; if it ends in .5, round ⬆️ . Most people have a similar answer, but that's NOT how #PowerQuery's ROUND function actually works. 😮 Learn more about it:
Power Query's Round Function
If you asked most people to round a number off, they would round .4 down and round .5 up, but that's NOT how Power Query's Round function actually works...
buff.ly
September 2, 2024 at 4:54 PM
A while ago, I asked a co-worker how many ways he knew of to round a number. His answer was 1: if it ends in .4, round ⬇️ ; if it ends in .5, round ⬆️ . Most people have a similar answer, but that's NOT how #PowerQuery's ROUND function actually works. 😮 Learn more about it:
TIL: #PowerQuery's list value's limit is 32 bit. Cool, since upon load to the data model its converted to 64 bit. Once again the bits! THE BITS!!!
November 18, 2024 at 3:29 PM
TIL: #PowerQuery's list value's limit is 32 bit. Cool, since upon load to the data model its converted to 64 bit. Once again the bits! THE BITS!!!
Tomorrow we’re tackling #PowerQuery’s Query Folding. My favorite parts, my less than favorite parts and of course diving into the deep end of why you should go long with M.
Also @alexdupler has taken our splash screens to the ridiculous next level.
https://youtu.be/scntZWMBY8Q
Also @alexdupler has taken our splash screens to the ridiculous next level.
https://youtu.be/scntZWMBY8Q
November 18, 2024 at 6:41 AM
Tomorrow we’re tackling #PowerQuery’s Query Folding. My favorite parts, my less than favorite parts and of course diving into the deep end of why you should go long with M.
Also @alexdupler has taken our splash screens to the ridiculous next level.
https://youtu.be/scntZWMBY8Q
Also @alexdupler has taken our splash screens to the ridiculous next level.
https://youtu.be/scntZWMBY8Q
5 minutes and counting! Quit scrolling and register now so we can push #PowerQuery's query folding limits!
#PowerBI #Excel #PowerQueryEverything !!!
https://www.meetup.com/dfw-power-bi-user-group/events/291047427/?chapterContext=true®ToRsvp=true&isFromReg=true
#PowerBI #Excel #PowerQueryEverything !!!
https://www.meetup.com/dfw-power-bi-user-group/events/291047427/?chapterContext=true®ToRsvp=true&isFromReg=true
403 Forbidden
www.meetup.com
November 17, 2024 at 4:59 PM
5 minutes and counting! Quit scrolling and register now so we can push #PowerQuery's query folding limits!
#PowerBI #Excel #PowerQueryEverything !!!
https://www.meetup.com/dfw-power-bi-user-group/events/291047427/?chapterContext=true®ToRsvp=true&isFromReg=true
#PowerBI #Excel #PowerQueryEverything !!!
https://www.meetup.com/dfw-power-bi-user-group/events/291047427/?chapterContext=true®ToRsvp=true&isFromReg=true
How has it taken me this long to discover
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
August 24, 2025 at 8:32 AM
How has it taken me this long to discover
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
New blog post:
A while ago I covered options within #PowerQuery's M code to replace text (outside the standard tool). I've come across 2 more recently, so here they are including:
Replace values in a col using ifs
Swap multiple values for another value
charitydatageek.blogspot.com/2024/11/repl...
A while ago I covered options within #PowerQuery's M code to replace text (outside the standard tool). I've come across 2 more recently, so here they are including:
Replace values in a col using ifs
Swap multiple values for another value
charitydatageek.blogspot.com/2024/11/repl...
Replacing values in Power BI revisited
charitydatageek.blogspot.com
November 18, 2024 at 1:04 PM
New blog post:
A while ago I covered options within #PowerQuery's M code to replace text (outside the standard tool). I've come across 2 more recently, so here they are including:
Replace values in a col using ifs
Swap multiple values for another value
charitydatageek.blogspot.com/2024/11/repl...
A while ago I covered options within #PowerQuery's M code to replace text (outside the standard tool). I've come across 2 more recently, so here they are including:
Replace values in a col using ifs
Swap multiple values for another value
charitydatageek.blogspot.com/2024/11/repl...
#PowerQuery's Refresh All is not always the best choice when working with multiple queries in #Excel. 🔄
@excelguru.ca shows how refreshing everything at once can accidentally wipe out manual updates — and why some workbooks need a staged refresh process instead:
@excelguru.ca shows how refreshing everything at once can accidentally wipe out manual updates — and why some workbooks need a staged refresh process instead:
Stop Using Refresh All: Refresh a Single Table!
In this video, Ken shows why Refresh All is not always the best choice when working with multiple Power Queries in Excel.
Using a practical credit card transaction example, you’ll see how refreshing…
www.youtube.com
June 10, 2026 at 4:38 PM
#PowerQuery's Refresh All is not always the best choice when working with multiple queries in #Excel. 🔄
@excelguru.ca shows how refreshing everything at once can accidentally wipe out manual updates — and why some workbooks need a staged refresh process instead:
@excelguru.ca shows how refreshing everything at once can accidentally wipe out manual updates — and why some workbooks need a staged refresh process instead:
That means there is no external file to delete or move, and users cannot accidentally break it. The trade-off is that to edit it, you must understand the ⚙ gear icon workflow in #PowerQuery's Query Editor.
June 1, 2026 at 5:05 PM
That means there is no external file to delete or move, and users cannot accidentally break it. The trade-off is that to edit it, you must understand the ⚙ gear icon workflow in #PowerQuery's Query Editor.
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. 📖 Maybe you need to discover a function, or maybe you just need more information on how it works. @excelguru.ca looks at 2 options:
Accessing Power Query Documentation 1 - Monkey Shorts Episode 027
Sometimes, you want to browse Microsoft's official documentation for Power Query's function library when you are writing a query. Maybe you need to discover a function, or maybe you just need more…
www.youtube.com
May 21, 2026 at 4:41 PM
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. 📖 Maybe you need to discover a function, or maybe you just need more information on how it works. @excelguru.ca looks at 2 options:
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
www.youtube.com
December 18, 2025 at 5:11 PM
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#PowerQuery's fill ⬇️/fill ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! In this episode of Monkey Shorts, @excelguru.ca will show you how:
How to unfill in Power Query - Monkey Shorts Episode 047
Power Query's fill down/fill up feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the Power Query user interface, but that…
www.youtube.com
October 23, 2025 at 4:16 PM
#PowerQuery's fill ⬇️/fill ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! In this episode of Monkey Shorts, @excelguru.ca will show you how:
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. In this Monkey Shorts, @excelguru.ca looks at 2 ways to do this:
➡️Microsoft's official website
➡️Using the #shared keyword inside the Power Query editor
➡️Microsoft's official website
➡️Using the #shared keyword inside the Power Query editor
Accessing Power Query Documentation 1 - Monkey Shorts Episode 027
Sometimes, you want to browse Microsoft's official documentation for Power Query's function library when you are writing a query. Maybe you need to discover ...
www.youtube.com
June 5, 2025 at 4:07 PM
Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when you are writing a query. In this Monkey Shorts, @excelguru.ca looks at 2 ways to do this:
➡️Microsoft's official website
➡️Using the #shared keyword inside the Power Query editor
➡️Microsoft's official website
➡️Using the #shared keyword inside the Power Query editor
When writing in #PowerQuery's formula bar, you might see helpful text that there are 1 of x arguments for the function. But when you try to click on item 2 of x, it disappears! 😡 In this video, @excelguru.ca shows how you can navigate through this shy little window:
Using Power Query Intellisense 2 - Monkey Shorts Episode 026
When writing formulas in the Power Query formula bar, you'll occasionally see helpful tooltip text that indicates that there are 1 of x arguments for the fun...
www.youtube.com
May 29, 2025 at 4:21 PM
When writing in #PowerQuery's formula bar, you might see helpful text that there are 1 of x arguments for the function. But when you try to click on item 2 of x, it disappears! 😡 In this video, @excelguru.ca shows how you can navigate through this shy little window:
In this Monkey Shorts episode, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use. Watch on YouTube: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
Column Profiling in Power Query - Monkey Shorts Episode 005
YouTube video by Skillwave Training
www.youtube.com
January 2, 2025 at 7:04 PM
In this Monkey Shorts episode, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use. Watch on YouTube: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools