Bluesky · Hashtag

#PowerQuery

33
posts · 30d
6
users
1
posts / day
5.5
posts / user
-44% vs last week

#PowerQuery is an active hashtag on Bluesky. In the last 30 days, 6 people shared 33 posts with it — around 1 a day. Activity is down 44% versus the previous week, peaking on Jul 15 with 4 posts.

#PowerQuery posts per day (last 30 days)

Related tags

Tags most often used together with #PowerQuery.

Posts with #PowerQuery

Ken Puls, FCPA, MS MVP
@excelguru.ca
2 days ago
With just a click, the Parameter Table & Function feature of our Monkey Tools add-in will insert the Parameter table and fnGetParameter function into your workbook. It even places the #Excel file path formula in the cell! 🙌 Learn more about it here: mkyt.ca/param-tbl #DataAnalytics #PowerQuery
Monkey Tools
Build better data models, faster
Developed by Excelguru
(Image of a cyborg monkey with its fist held up for a fist bump)
Parameter Table and Functions
(Screenshot of Power Query showing the inserted Parameter table and fnGetParameter function)
If you're a fan of the fnGetParameter function (as per Chapter 17 of Ken's 'Master Your Data' book), you'll love this Monkey!
monkeytools.ca
0 0 2
Skillwave Training
@skillwave.training
2 days ago
Ugh, you have a TXT file where each entry consists of multiple lines, and you need it all in a nice, clean table. Instead of manually copying and pasting each line into a column, use #PowerQuery! 😎 Check out our full 👨‍🍳 recipe collection at skw-t.com/pqrecipes #Excel #PowerBI #DataPreparation
Master Your Data in Excel & Power BI
Pivoting Stacked Data Recipe
- Add a columns for transaction and line IDs
	- Add Column -> Index Column -> From 0
	- Select [Index] -> Add Column -> Standard -> Integer-Divide*
	- Select [Index] -> Transform -> Standard -> Modulo*
- Pivot the data
	Select [Index] -> Transform -> Pivot Column
	- Set the Values field to your data column
	- Open the Advanced option and “Don’t Aggregate”
- Right click the [Integer-Division] column -> Remove
- Rename the newly created columns
- Set your data types
*Modulo and Integer Division always target the number representing the 1st row of the 2nd transaction
Recipe 10.120.2112
For more data patterns, check out our courses at skillwave.training
0 0 1
Wyn - Power BI & Excel
@wynhopkins.bsky.social
about 2 years ago
Too many thoughtless answers on Power BI forums are “do it in the SQL database” Most Power BI users don’t have access to SQL / don’t need to learn SQL / don’t want to learn SQL #PowerQuery #Exports
3 2 11
Wyn - Power BI & Excel
@wynhopkins.bsky.social
9 months ago
Stuff all the AI announcements. This is the best news so far... From SharePoint Folder is now available regardless of which subscription plan. Business Premium users rejoice! Looks like a few other connectors have lit up too! If you're on an M365 plan then check it out now #Excel #PowerQuery
0 0 9

Posts are pulled live from Bluesky and cached briefly. Posts with content labels are hidden.