##PowerQuery
LightNews LightNews
skillwave.training
Don't forget: daylight savings ends in North America on Sunday, November 2. ☀️ 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 #DataAnalysisTools
(Skillwave Training logo) Image of a cyborg monkey leaping into the air, cheering with its fist raised. A thought bubble next to the monkey says: "Let’s see, it’s fall back, spring ahead... YES, an extra hour of sleep this weekend!" (Skillwave Training logo) Screenshot of the Power Query Recipe card 60.910.x, which outlines the steps to convert UTC DateTime to local DateTime 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.
October 31, 2025 at 4:20 PM
excelguru.ca
Today was the Day 1 of my in-person #SelfServiceBI Boot Camp in Munich. 👨‍🏫 We began with an overview of the #BusinessIntelligence ecosystem, then reviewed #Excel #PivotTables, and wrapped up the day by beginning the dive into #PowerQuery.
Photo of a meeting room set up awaiting the attendees for Day 1 of Ken Puls' Self Service BI Boot Camp in Munich, Germany. There is a long table with chairs around, and a flip chart and screen at the far end of the room. Which Technology Gets Used Where? Image of 5 bubbles indicating the various stages of the business intelligence ecosystem. The bubbles arranged in a circle with arrows pointing from one bubble to the next and labels of which technology is used at each stage: - Get & Transform Data (Power Query) - Relate Tables into a “Model” (Power Pivot Data Model) - Generate Measures & Analytics (PivotTables and Formulas) - Create Visuals (Tables, Pivots, Charts & More...) - Share & Explore (Email, SharePoint & Power BI)
October 27, 2025 at 7:54 PM
powerbiweekly.endj.in
How to Handle Multiple Date Columns in Power BI by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=sqkH...
Solve Sales vs Delivery Date Problems in Power BI
In this video, I’ll show you how to solve one of the most confusing Power BI problems, working with data that has two date columns, like sales date and deliv...
www.youtube.com
October 22, 2025 at 7:40 PM
excelguru.ca
I love hearing from happy students! 😁
In my #Excel Fundamentals Academy at @skillwave.training, you’ll learn all the core skills needed by a #DataAnalyst, including #ExcelFormulasAndFunctions, #PivotTables, #DataVisualization, and #PowerQuery. Level up your Excel skills, go to skw-t.com/excelfun
Testimonial "Great content overall, topped with some solid gold nuggets! I also love Ken's teaching style and rather dry sense of humour. Last but not least, I posted a question which was responded to in no time. Not only that, Ken went above and beyond to have it resolved. I was absolutely blown away by the level of service!" Mark S. (5 stars) Excel Fundamentals Academy (Caricature of Ken Puls) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave Training logo)
October 16, 2025 at 7:27 PM
excelguru.ca
🔎QuerySleuth is a must-have for every #PowerQuery user. Developed based on a real business need, we believe this form will add magic to your ability to trace query dependencies and precedents. And it does it all without locking your #Excel UI! Learn more: mkyt.ca/querysleuth

#DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth TreeView allows you to easily browse your queries. And you can quickly flip between showing precedents (the default view), dependents, or turn the tracking off entirely if needed. Plus, when looking at the M code of a query, any precedent queries are highlighted right in the code. (Screenshot of the TreeView in QuerySleuth with the various queries highlighted by colour code) monkektools.ca
October 15, 2025 at 4:15 PM
rezarad.bsky.social
Did you know that there are at least THREE major benefits of creating #calculated column in #PowerQuery instead of #DAX?

If you are creating #calculations in #PowerBI, then you must read this. I showed using a live demo how this works in my today's video;

youtu.be/6fU5Ih2b-w4
The Best way to create a Calculated Column in Power BI Power Query Custom Column
YouTube video by RADACAD
youtu.be
October 14, 2025 at 4:08 PM
amitchandak.bsky.social
Power BI Update – What’s New in September 2025

www.youtube.com/watch?v=CQVQ...

#PowerBI #DataAnalytics #BusinessIntelligence #DAX #PowerQuery #MFunctions #Dashboard #Visualization #AnalyticsTraining #ProfessionalDevelopment #LearningJourney
Power BI Update - September 2025
YouTube video by Microsoft Power BI
www.youtube.com
September 16, 2025 at 7:10 AM
excelguru.ca
DYK that when merging columns in #PowerQuery, the behaviour is different depending on whether you trigger it from the Transform or Add column tabs? 😱 Let's explore why adding a new column may be a better option than transforming existing ones: https://buff.ly/4gMixeJ

#Excel #PowerBI #DataAnalysis
Merging Columns with Power Query - Monkey Shorts Episode 041
Did you know that when merging columns in Power Query, the behaviour is different depending on whether you trigger the command from the Transform or Add colu...
buff.ly
October 4, 2024 at 4:01 PM
itsnotaboutthecell.com
Today's #PowerQuery love is brought to you by Table.RemoveMatchingRows() - is there anything this language can't do?... thank you @MSPowerQuery

https://docs.microsoft.com/en-us/powerquery-m/table-removematchingrows
Table.RemoveMatchingRows - PowerQuery M
Learn more about: Table.RemoveMatchingRows
docs.microsoft.com
November 18, 2024 at 2:16 AM
itsnotaboutthecell.com
Today's #PowerQuery "M"agic of the day brought to you by 404 error handling with Web.Contents().

https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
Chris Webb's BI Blog: Handling 404–Not Found Errors With ...
One strange feature of the Web.Contents() function in Pow...
blog.crossjoin.co.uk
November 18, 2024 at 1:46 AM
itsnotaboutthecell.com
Quit scrolling and jump in now! #PowerQuery #PowerBI #Excel

https://www.meetup.com/Portland-Power-BI-User-Group/events/282293830/
403 Forbidden
www.meetup.com
November 17, 2024 at 9:51 PM
itsnotaboutthecell.com
#PowerQueryashtag/PowerQueryEverything" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link">#PowerQueryEverything !!! With more and more connectors now available in #PowerBI and #PowerQuery online!

https://powerquery.microsoft.com/en-us/blog/new-certified-connectors-available-in-power-bi-dataflows-and-datamarts/
What is Power Query? - Power Query
Learn what Power Query is, and how it can help you get an...
powerquery.microsoft.com
November 17, 2024 at 9:16 PM
itsnotaboutthecell.com
Loving how many people are learning about #PowerQuery parameters to limit/test rows today! Awesome stuff @parvchana !!!
November 17, 2024 at 7:07 PM
itsnotaboutthecell.com
I guess the good part about being stuck inside as #MardiGras descends on my neighborhood is that I'm just going to knock out some content. Expect more videos to continue to trickle out as I work through my agenda for "An Introduction to #PowerQuery M"

https://youtu.be/tegvFYOn-sI
November 18, 2024 at 9:11 AM
itsnotaboutthecell.com
The things I would do for bulk editing activities across multiple queries... #PowerQuery
November 17, 2024 at 9:16 PM
tobiasbrandt.bsky.social
It's time for devs to take a look at modern #Excel! It now has all the core #FunctionalProgramming constructs: LAMBDA, LET, MAP, REDUCE, SCAN, … as well as GROUPBY, PIVOTBY, …

Both #PowerQuery and Formulas have lazy evaluation.

It's a fantastic, reactive, functional programming environment! 🚀
charles.dardaman.com Charles @charles.dardaman.com · Nov 7
The only answer is Excel
#databs #datasky
sarahkb.bsky.social Sarah Krasnik Bedell @sarahkb.bsky.social · Nov 6
Alright #databs time for a trial run

What one type of technology would you consider the heart and soul of your data stack?
November 7, 2024 at 5:39 AM
powerbiweekly.endj.in
Understanding Semi Joins in #PowerQuery M by Rick de Groot #PowerBI https://gorilla.bi/power-query/understanding-semi-joins/?utm_source=bluesky&utm_medium=social&utm_campaign=powerbiweekly
Understanding Semi Joins in Power Query M - BI Gorilla
Learn how to use the Left and Right Semi Join allow to filter a table to return only those rows that exist in another table.
gorilla.bi
September 11, 2024 at 9:50 PM
wynhopkins.bsky.social
#PowerQuery Fail?

When Clean does not work...

youtu.be/61qnHOcXvLs&...

#Excel #PowerBI
February 19, 2025 at 11:16 AM
john.whites.site
Power BI Data Management Gateway 1.2 Changes the Game - http://whitepages.unlimitedviz.com/2014/08/power-bi-data-management-gateway-1-2-changes-the-game/ . #PowerQuery is now the focus #PowerBI #Office365
Power BI Data Management Gateway 1.2 Changes the Game
whitepages.unlimitedviz.com
December 5, 2024 at 11:10 PM
powerbiweekly.endj.in
Short Month Names using DAX by Sunil Mathew #Data #PowerQuery #excel #PowerBI https://www.youtube.com/watch?v=kQywpQmGbL8?utm_source=bluesky&utm_medium=social&utm_campaign=powerbiweekly
Short Month Names using DAX | Power BI Tutorial
In this video, I demonstrate how to efficiently shorten month names (e.g., January, February, March) to their abbreviated forms (J, F, M) in Power BI. This q...
www.youtube.com
January 8, 2025 at 8:40 PM
excelguru.ca
Looking to expand your #DataAnalytics skills and build your #BusinessIntelligence toolkit? 🧰

👀 Keep your eyes peeled starting tomorrow for the BIGGEST SALE EVER on our @skillwave.training learning platform!

#DataModeling #DataAnalysis #DataViz #PowerBI #Excel #DAX #PowerQuery #DataInsights
June 30, 2025 at 4:52 PM
edwardsdna.bsky.social
Power BI Conditional Column Tutorial:No Custom Column Needed: Learn how to build Custom Column and Conditional Columns in Power BI; in this concise tutorial I walk you through the Power Query Editor step by step. @PowerBI #PowerBI #DataAnalytics #BusinessIntelligence #PowerQuery #DataVisualization
Power BI Conditional Column Tutorial:No Custom Column Needed
Learn how to build Custom Column and Conditional Columns in Power BI; in this concise tutorial I walk you through the Power Query Editor step by step.
dlvr.it
July 12, 2025 at 7:04 PM
powerbiweekly.endj.in
The 8 Biggest Mistakes Behind 80% of Report Problems by Chandeep Chhabra #PowerQuery #businessintelligence #excel #PowerBI www.youtube.com/watch?v=Tw7D...
The 8 Biggest Mistakes Behind 80% of Report Problems
https://youtu.be/yw0QHu9V4UQ?si=l4R_qJCZlnYP87nwIn this video, I share the most common (and often stupid) mistakes I keep making in Power BI and how you can ...
www.youtube.com
September 26, 2025 at 3:20 AM
excelguru.ca
By default, when you unpivot a set of data in #PowerQuery, all null records are suppressed. But what if you need them in your unpivoted data set? 🤷 Here, I'll show you 2 different methods and discuss the impacts of each: www.youtube.com/watch?v=-j_q...

#Excel #PowerBI #DataCleaning #DataAnalysis
Keep null Values During UnPivot Operations - Monkey Shorts Episode 043
By default, when you unpivot a set of data in Power Query, all null records are suppressed. But what if you need them in your unpivoted data set? In this week's episode of Monkey Shorts, Ken shows…
www.youtube.com
September 26, 2025 at 4:46 PM
itsnotaboutthecell.com
For the next Two Alex’s me and @alexdupler are tackling #PowerQuery - I’ve got a simple question to ask you. What do you NEED to know?

I ask because @CurbalEN had an interesting thread on #PQ and I was shocked at the responses. What would help you in deciding to go all in???
November 18, 2024 at 7:21 AM