Latest posts tagged with #powerquery on Bluesky
Welcome to the club! Wait until you discover M language in the Advanced Editor. That's when Power Query goes from "wow" to "how did I ever live without this." Pro tip: learn to use List.Generate and Table.Combine early, they'll save you hours. #PowerQuery #Excel
It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what Power Query actually does when you do this? 🫣
Here, I show how can get burned, as well as how you can take granular control to set up filters:
100%! Power Query is a game changer. The moment you realize you can connect to multiple sources, merge tables, and refresh everything with one click... there's no going back to manual copy-paste. It's like discovering a superpower you always had but never used. #PowerQuery #Excel
Once you get comfortable with the Advanced Editor, try using "let" to chain steps manually. It gives you way more control than the UI, especially for custom columns and conditional logic. The M language is surprisingly powerful once it clicks! #PowerQuery #Excel
It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what PQ actually does when you do this? 🫣
@excelguru.ca shares how you can get burned, as well as how you can take granular control to set up filters:
I've been having a great week doing some consulting work and leading a #PowerQuery course for a private client. There's nothing better than introducing people to the #DataCleaning and #DataPreparation magic performed by Power Query! 📈🧹
Contact us for private team training: excelguru.ca/contact-us/
¿Ajustas las conexiones de Power Query cada vez que compartes un Excel?
Con la función CELDA + rangos con nombre puedes hacer que las rutas se actualicen solas. Nunca más ajustes manuales 👇
https://youtu.be/fuLnCjmCQUY
#Excel #PowerQuery #Influexcel
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Create Query From M Code This Monkey allows you to create and configure a query from M code, without ever leaving the Excel interface! Just launch the Monkey, give the query a name, and past the code into the formula box. Plus, it automatically indents the code so it's easier to read! (Screenshot of the Create Query from M Code dialog with a query name of "Budget" in the Name field and the indented and coloured M code below, along with the other options such as load destination, formatting options, and what action to take if the query exists.) monkeytools.ca
If you want to reuse a query, it can be tedious to open #PowerQuery, then the Advanced Editor, then paste, close, rename, and finally choose load destination. 😫
The “Create Query From M Code” Monkey will create the query for you without ever leaving the #Excel interface! 🙌 See how at mkyt.ca/mquery
The thing where adding a null to a value gives a null is a real weakness in #PowerQuery. How many people have missed this & not realised I wonder? Anyway, easy fix: use the coalesce function, or just put a ?? 0 after each column name that might contain a null.
See www.youtube.com/watch?v=-FQr...
Great pattern! Another trick: if you want to keep the zeros visible but exclude them from Count, use COUNTA on a column where you replaced 0 with null, and keep the original for display. Best of both worlds. Power Query makes this kind of dual-column approach trivial. #PowerQuery #Excel
The Two-Second Fix for Counting Problems Problem: Your PivotTable is counting all rows in a column, even those with zeros. Solution: Replace zeros with nulls in Power Query! While "zero" is a number that Excel counts, "null" is empty and gets ignored. (Screenshot of a table containing data on the left and a PivotTable based on that data on the right. The Grand Total count on the PivotTable columns do NOT include the "0" entries.) (Skillwave Training logo)
One of our AKA participants wanted to know why their #PivotTable was inflating their counts numbers. They only wanted to count active line of credit accounts, but their count was including everything, even those with $0 balances. My solution? Replace zero with null in #PowerQuery. It's that simple!🧵
Evaluate #PowerQuery Programmatically in #microsoft Fabric (Preview) by Mihir Wagle #Data #excel #PowerBI blog.fabric.microsoft.com/en-US/blog/e...
Great tip! MissingField is one of those hidden gems in Power Query. MissingField.UseNull is especially handy when loading CSVs that sometimes have extra or missing columns — your query won't break, it just fills nulls. Saves a lot of "column not found" headaches. #PowerQuery #Excel
How to create a column in #PowerQuery from example for Power BI or #excel by Learning Science #PowerBI www.youtube.com/watch?v=LTYw...
A student asked why a #PivotTable counts 3 Lines of Credit as “used” when one of them has a zero balance and shouldn’t be counted. 🤷🏾 And do you need #PowerPivot and #DAX to fix it?
Nope! @excelguru.ca shows it takes just simple data-prep adjustment in #PowerQuery:
#PowerQuery: Choice Values for #PowerApps/Dataverse Picklist and Boolean Columns by Ben Gribaudo #PowerBI bengribaudo.com/blog/2026/02...
4 Essential Queries for Cleaner Power BI Models by Chandeep Chhabra #PowerQuery #businessintelligence #excel #PowerBI www.youtube.com/watch?v=ZQEg...
New blog post: Did you know that there is a MissingField parameter in some Power Query table and record functions to tell it what to do if the columns in your data change from time to time? #PowerQuery
jenkuntz.ca/2026/03/powe...
Want to master data cleaning and transformation?
Want to master #DataCleaning and #DataTransformation, and automate your #BusinessIntelligence? Our #PowerQuery Academy has helped thousands of #DataAnalysts in diverse fields to use Power Query and save hours of time and manual effort.
🎯Get started today with our FREE intro course: skw-t.com/pqfun
Image of a a cyborg monkey sitting thoughtfully while resting its chin on its hand. A thought bubble is next to it that says: Let's see, it's fall back, spring ahead... Ah nuts, one less hour of sleep this weekend!" (Skillwave Training logo)
![(Skillwave Training logo)
Power Query Recipes
Master Your Data in Excel and Power BI
Pattern Difficulty = Easy
Convert UTC DateTime to Local DateTime Recipe
Step 1: Add a UTC time zone (if your data has time zones, skip to Step 2)
- Right click the [Original] column -> Change Type -> DateTime
- Go to Add Column -> Custom Column
Name: DateTimeLocal
Formula: DateTime.AddZone([Original],0)
- Right click the [Original] column -> Remove Column
Step 2: Convert the [DateTimeLocal] column to your local time zone
- Select the [DateTimeLocal] column -> Transform -> Time -> Local Time
- Right click the [DateTimeLocal] column -> Change Type -> [Date or DateTime as desired]
NOTE: This recipe is Daylight Savings Time aware! If you do not want this volatility in your transformation, see Recipe 60.920.x to lock in a time zone.
Course Subscribers: Click the icons to see this recipe in action! (Icon for Power Query Academy video)
For more data patterns check out our courses at www.skillwave.training
Recipe: 60.910.2306](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreiechihojcilzdc7tw7gf5wtu3jt6uvcyla4fpmgaboneyeqnnjtwa)
(Skillwave Training logo) Power Query Recipes Master Your Data in Excel and Power BI Pattern Difficulty = Easy Convert UTC DateTime to Local DateTime Recipe Step 1: Add a UTC time zone (if your data has time zones, skip to Step 2) - Right click the [Original] column -> Change Type -> DateTime - Go to Add Column -> Custom Column Name: DateTimeLocal Formula: DateTime.AddZone([Original],0) - Right click the [Original] column -> Remove Column Step 2: Convert the [DateTimeLocal] column to your local time zone - Select the [DateTimeLocal] column -> Transform -> Time -> Local Time - Right click the [DateTimeLocal] column -> Change Type -> [Date or DateTime as desired] NOTE: This recipe is Daylight Savings Time aware! If you do not want this volatility in your transformation, see Recipe 60.920.x to lock in a time zone. Course Subscribers: Click the icons to see this recipe in action! (Icon for Power Query Academy video) For more data patterns check out our courses at www.skillwave.training Recipe: 60.910.2306
It's that time of year again... daylight savings begins in North America on Sunday, March 8. Luckily, our #PowerQuery recipe for converting a UTC DateTime to a Local DateTime is daylight savings aware. Get the full recipe collection at skw-t.com/pqrecipes
#Excel #PowerBI #DataAnalytics
Why does a #PivotTable count three Lines of Credit as “used” when one of them has a zero balance and shouldn’t be counted? 🤷🏾 And more importantly — do you need #PowerPivot and #DAX to fix it? Here, I'll show you that you don't: youtu.be/-X-ELoJ9Kiw
#PowerQuery #ExcelTips
¿Power Query tarda minutos en actualizar? Con SQLite puedes mejorar el rendimiento un 90%. Nacho Cardenal lo explica paso a paso en este podcast con Sergio A. Campos 👇 https://www.youtube.com/live/b4f4ozxIrUo #Excel #PowerQuery #Influexcel
(Excelguru logo) Passionate Instruction, Practical Skills Unlocking Your Team's Potential via Industry Leading Training The biggest issue facing corporate efficiency today is not recognizing what you already have and how to leverage it. Our training will help your team expand their knowledge of Excel and Power BI, find solutions, and be more proficient or accomplish certain tasks. Learn more about our in-person and online training options at excelguru.ca (Microsoft Excel and Power BI icons) (Headshot of Ken Puls)
Delivering expert training BY humans, FOR humans, Excelguru is dedicated to unlocking your team’s potential through:
🔹On-site workshops
🔹Online coached courses
🔹On-demand video courses
Contact us today for training options at excelguru.ca
#Excel #PowerBI #DataModeling #PowerQuery #DataAnalysis #DAX
¿Power Query tarda mucho? Si invocas funciones personalizadas fila a fila, cada una se evalúa por separado.
Truco: Table.Buffer cachea resultados intermedios y reduce el tiempo de carga drásticamente.
Caso práctico 👇
https://www.youtube.com/watch?v=_3grJCyHW-8 #Excel #PowerQuery
#PowerQuery is a data connection technology that enables you to discover, connect, combine, and refine data sources for #DataAnalysis. It adds ETL capability to #Excel and #PowerBI. 💪
Start learning how it can save you a ton of time and manual effort with our FREE intro course: skw-t.com/pqfun
Okay, maybe you knew the tip from last week's Monkey Shorts on how to zoom in the #DAX font size. But do you know how to do it in the #PowerQuery editor? 🤔 Today, I'll show how to to control the zoom level and font size in the PQ editor window: www.youtube.com/watch?v=NThh...
#Excel #PowerBI
Okay, maybe you knew the tip from last week's Monkey Shorts on how to zoom in the #DAX font size. But do you know how to do it in the #PowerQuery editor? 🤔 Today, @excelguru.ca shows how to to control the zoom level and font size in the PQ editor: www.youtube.com/watch?v=NThh...
#Excel #PowerBI
The Classic Excel Answer 5 Step Process: Import data > Make contiguous range > Sort > Filter and cull > Cleanup Drawbacks: - Tedious - Complicated - Have to re-live it every time (copyright Skillwave Training)
Dealing with Data in Modern Excel Icons on the left of the slide representing various data types, such as databases, emails, file folders, documents, and websites Arrow pointing to the right with text on it: "Rich array of transformation tools in one place" Spreadsheet + One-click Refresh = Happy Face (copyright Skillwave Training)
I had another great day of in-person training for a private client, this time exploring the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning, and transforming data in #Excel or #PowerBI, you know how tedious it can be. Power Query will save you hours of time and effort. 😎
I used this moment to show how a single #PowerQuery Calendar table could be connected to multiple data fields in the Fact table using inactive relationships. From there, with a little CALCULATE magic in a #DAX measure he unlocked multi-date reporting cleanly.
News from the Data Monkey Brought to you by Excelguru and Skillwave (Image of a cyborg monkey in a superhero type crouch) February 24, 2026 In This Issue: - New Video on Excel TRIMRANGE() & the Dot Operator - From the AKA Sessions - Latest Meet-up Recording and Next Event Information - Upcoming Courses and Conferences - Available Training Options Another month has flown by with Ken hosting and presenting at various Power BI and Modern Excel Meet-ups, helping students in the live 'Ask Ken Anything' sessions, and leading his first course of the year for Chartered Professional Accountants of BC. This week, Ken is excited to be delivering two days of live, on-site training for a private client. He LOVES being in person with students! However, if you can't join him live, we have the next best thing: 20% off all of our on-demand video courses (excluding 'Ask Ken Anything' subscriptions). All you have to do is register by February 28, 2026 and apply this code at checkout: LOVE20
The latest edition of our newsletter is hitting inboxes now! 📨
If you'd like to stay up-to-date on the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more, subscribe at skw-t.com/news
📗 You'll also our free #PowerQuery eBook.
