Grilled Cheese

ExploreLog inSign up
Terms of UsePrivacy PolicyCommunity StandardsHelpGet the app

Grilled Cheese is a product of Village Compute

Version devBuilt at: 2026-10-16 19:33:48 EDT

PhotosVideosAllPeople
LatestRanked
@skillwave.trainingOct 6, 2026, 5:08 AM

A question sent in for our recent 'Ask Ken Anything' (AKA) session tackled a common reporting headache: how do you compare hours logged in a project management system against data from time-tracking software? 🕒
@excelguru.ca walked through a solution he built using #PowerQuery and #PowerPivot. 🧵

Turning Durations Into Hours A student asked how to compare hours logged in a project management system against data from time-tracking software. Ken Puls’ solution used Power Query to clean and transform the data from both sources into a common data type, which could then be more easily compared! (Screenshot of the Power Query Editor displaying the initial time tracker data in the Screen Time columns as miniscule decimals. The Transform > Duration > Total Hours options from the ribbon are highlighted, which then displays the converted values in Screen Time column.) (Skillwave Training logo)
@excelguru.caOct 5, 2026, 5:39 PM

♥️#PowerQuery

@skillwave.trainingOct 5, 2026, 5:33 PM

Unlock the power of #DimensionalModeling by learning the right way to build solid and scalable Data Models in #Excel and #PowerBI.💪 This course pairs #PowerQuery and the #DataModel together using each for what they were designed to do.
➡️Transform your #BusinessIntelligence skills: skw-t.com/modeling

At the core of every BI solution is the Data Model. But do you really know how to work with it properly? Dimensional Modeling for the Excel and Power BI Pro (Image of a man sitting in front of a laptop with a cup of coffee beside him. His left hand is on his chin and he's looking up and to the right.) Start Learning (Skillwave Training logo)
@skillwave.trainingOct 2, 2026, 5:26 PM

Following up on the Monkey Shorts episode shared yesterday, here's our #PowerQuery Recipe card that outlines the steps to number your data by grouped rows. 👩‍🍳 You can get the full collection (over 95 handy recipes!) at skw-t.com/pqrecipes

#Excel #PowerBI #DataTransformation #DataPreparation

Master Your Data in Excel & Power BI Pattern Difficulty: Lo Code Number Grouped Rows Recipe Initial Preparation Sort any [Dimension] column(s) to group the data Sort the [Fact] column -> Descending Re-apply the column data types Group the Data Go to Transform -> Group -> Advanced Group by the [Dimension] column(s) Add a new column called “Data” -> All Rows Add Row Numbers Go to Add Column -> Custom Column Name: Custom Formula: =Table.AddIndexColumn([Data], "Index", 1, 1) Right click the [Custom] column -> Remove Other Columns Expand all columns from [Custom] Re-order the columns if desired (Image of a Source Table containing data first listed by Group, then category. A second Table With Numbered Rows image shows the addition with an index column where each Category within a Group is numbered sequentially by row.) DBAs know this output as using SQL’s ROW_NUMBER with PARTITION For more data patterns, check out our courses at skillwave.training
@excelguru.caOct 2, 2026, 5:17 PM

AKA "number rows by partition" this is a useful recipe to have in your #PowerQuery arsenal. The basic goal is to provide each item in a group with a row number, restarting the numbering at row 1 when we move to the next group. 🔢 With the right recipe, it's very easy: www.youtube.com/watch?v=9ckP...

@vtdarksim.dmv.community.ap.brid.gyOct 1, 2026, 10:34 PM

I just stumbled upon adding comments to #PowerQuery #Mcode and I think my life may be forever changed in yet indiscernible ways.

@skillwave.trainingOct 1, 2026, 5:09 PM

AKA "number rows by partition" this is a useful recipe to have in your #PowerQuery arsenal. The basic goal is to provide each item in a group with a row number, restarting the numbering at row 1 when we move to the next group. 🔢 @excelguru.ca shows it's very easy: www.youtube.com/watch?v=9ckP...

@excelguru.caSep 30, 2026, 5:40 PM

We heard from European friends that they aren't fans of the N American week numbering systems. 📆 #PowerQuery has a “week number” function but no function to get ISO weeks. Well, our Monkey Tools #Excel add-in will inject a GetISOWeek function.✋ Learn how it works here: mkyt.ca/get-iso-week

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Get ISO Week Function This function allows you to pass in two data points: a date and an optional "precise" choice. These return a properly formatted week number based on the ISO 8601 standard. (Screenshot of Invoke Custom Function dialog in Power Query with fnGetISOWeek in the query field and the options for setting the column name, the given date, and the optional "precise date format" fields.) monkeytools.ca
@skillwave.trainingSep 30, 2026, 5:31 PM

Final takeaway: Take the output of #PowerQuery, feed it back into itself, and build a self-growing forecast history system—just make sure to remove duplicates before appending.
If you work with forecasts, budgets, or projections that change over time, this is a simple but powerful pattern. 👍

@goatshipmate.bsky.socialSep 30, 2026, 9:30 AM

These little fellas are a real step forward though.
The "Query" one lets you choose between viewing the whole query formula or just that step. The "Diagram view" lets you see a new interface of the relationships. It's messy but lots more functionality.
#PowerQuery #PowerBI

Photo, no descriptionPhoto, no description
@goatshipmate.bsky.socialSep 30, 2026, 8:28 AM

Microsoft obligingly providing extra material for this thread by getting rid of the Quick access toolbar in #PowerQuery. Needless vandalism. I'm utterly reliant on using Alt+2 to open the editor window. A slap in the face for those of us trying to take the product seriously.

Screen grab of the – now empty – area where the quick access toolbar used to reside, and a higlight of where I have to click from here on in.
@goatshipmate.bsky.socialSep 30, 2026, 8:20 AM

Ooh. The September update of #PowerBI now has icons for each step in #PowerQuery. Looks a bit busy with my use of a ♠ to highlight unstraightforward steps, but that's my issue!
What do you think about this?

Screen grab of the "applied steps" window in Power Query with some example names and the new (and my old) icons showing. "Source" is preceded by a csv icon, Filtered Rows by a filter icon etc.
@excelguru.caSep 29, 2026, 5:24 PM

In this new video, I show the different types of blanks that can show up in #PivotTables built from the #DataModel. 🙃 If you work with #Excel PivotTables, #PowerPivot, #DAX measures, or #PowerQuery, this will help you understand where blanks come from and how to deal with them: youtu.be/fnVUJmHUTwc

@skillwave.trainingSep 29, 2026, 5:11 PM

#PowerQuery caches preview values inside the file, so the Query Editor and hover cards can show stale results even after Refresh All has loaded fresh data to the worksheet. 🔄 It's even more likely if background data previews have been turned off to speed up large workbooks.

@goatshipmate.bsky.socialSep 28, 2026, 9:34 AM

I knocked up a little system to automatically track the files I've been working on. #AutoHotKey notes down any changes of the active window in a .csv, #PowerQuery tidies it up in #Excel. Not sure if the conditional formatting is a bit much: it's uncouth but useful, I guess.

Photo, no description
@excelguru.caSep 25, 2026, 6:30 PM

In this Monkey Shorts, I explore a #PowerQuery trick to fix non-aligned data. It all started with a PDF import where data shifted into different columns on different rows.👎
It all ended with success, and a recipe to solve this challenge for others!👍https://www.youtube.com/watch?v=TC_gRjjCnm0

#Excel

@skillwave.trainingSep 25, 2026, 5:22 PM

Transform your #DataAnalysis skills and kickstart your career like Dillon has! 👑 Join our #PowerQuery Academy and reap the rewards of efficient data handling in #Excel and #PowerBI. 💪 Enroll today at skw-t.com/pqa

Kickstart Your Career with Power Query Power Query Academy: Intermediate to Advanced "This course got me a promotion from Senior Accounting Associate to Financial Analyst. Thank you Matt, Ken and Miguel for giving me this opportunity. I liked that it was very well structured and can be taken at own pace." Dillon B. (5 stars) (Skillwave Training logo) skillwave.training
@excelguru.caSep 25, 2026, 4:04 PM

What a great way to wrap up the week! Today, I'm leading some training for a private client, exploring the awesomeness of #PowerQuery. 😎 If you spend time manually gathering, cleaning, and transforming data, you know how tedious it can be. PQ will change your work forever in #Excel or #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 timeDealing with Data in Modern Excel Various data types/sources (database, website, files, folders, emails, etc.) -> Rich array of transformation tools in one place -> Load into worksheet + One-click refresh = Smiley face
@chinarelliti.bsky.socialSep 24, 2026, 3:02 PM

🚨 **Sua empresa tem muitos dados… mas será que realmente tem informação?**

🔥 **Leia o artigo e descubra onde sua empresa pode estar perdendo valor sem perceber.**
fpw.com.br/m/dados-sua-...

E depois me conte nos comentários:

#GestaoDeDados #Dados #Excel #PowerBI #PowerQuery

Photo, no description
@skillwave.trainingSep 23, 2026, 6:16 PM

Here, @excelguru.ca explores a #PowerQuery trick to fix non-aligned data. It all started with a PDF import where data shifted into different columns on different rows.👎
It all ended with success, and a recipe to solve this challenge for others! 👍
www.youtube.com/watch?v=TC_g...

#Excel #PowerBI

Load more