#powerquery zoekresultaten
How to convert a text file to #Excel using #PowerQuery 📁 Follow these steps: 1️⃣ Go to Data → Get Data → From File → From Text/CSV 2️⃣ Browse for your text file and click Edit to open Power Query 3️⃣ Remove irrelevant rows → Home → Remove Rows 4️⃣ Clean up messy text →…
How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery
Manually copying PDF data into Excel? 😩 There’s a faster way! Use Power Query to import tables perfectly in seconds. No mess, no reformatting. 🚀 This is a next-level tip. Watch: youtu.be/YuvYflYkuVg #Excel #ExcelTips #PowerQuery #Microsoft365
youtube.com
YouTube
Import PDF Data Into Excel in Seconds (No More Messy Copy-Paste)
Think you can turn a folder of #Excel files into a dynamic sales report? 😎 That’s what this month’s GoSkills Excel Challenge was all about! Watch Microsoft MVP @IlgarZ’s solution and see how to: ✅ Combine multiple files using #PowerQuery ✅ Use PivotTables to spot trends and…
After the Microsoft Fabric Conference, there's a feeling Power Query may have finally turned a corner. With improvements in cost-effectiveness and ease of use, it may be time to revisit dataflows and give them another look. #PowerQuery #MicrosoftFabric youtube.com/watch?v=sC1B5s…
Hey #DataFam 🫢 A 4-Year January Sales Overview (2018–2021) filtered by business segment. From Power Query ➡️ Power Pivot ➡️ DAX ➡️ Pivot Tables = Excel magic. No VBA. No add-ins. Just pure Excel. Thanks y’all for the support always 🫶❤️ #Excel #PowerQuery #DAX #Dashboard
Messy data? @awsaxton cleans, folds, parameterizes, then loads. #PowerQuery fun! Plus a quick look at Dataflows Gen2 folding indicators & Query Plan. Build along! #PowerBI 👉 guyinacu.be/powerquerybegi…
Want an Excel dashboard with no manual entry? Automate as much as possible using Power Query. "Really learn how to use pivot tables." #ExcelTips #PowerQuery
Think you can turn a folder of #Excel files into a dynamic sales report? 😎 That’s what this month’s GoSkills Excel Challenge was all about! Watch Microsoft MVP @IlgarZ’s solution and see how to: ✅ Combine multiple files using #PowerQuery ✅ Use PivotTables to spot trends and…
📊 ExcelでJSONを読み込む？ こんにちは、#阿久梨絵 です！ Power Queryを使えば、ノーコードでAPI連携までできちゃうんです✨ 表計算の枠を超えた“安心設計”をまとめました。 #Excel活用 #PowerQuery #API連携 #JSON #業務改善 👇 記事はこちら aqlier.com/2025/10/13/exc…
How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery
でもこれ同じことを、5年前は #VBA でやっていた。処理手順ももっと煩雑だった。それ考えると、少しは成長したかな。。。 #PowerQuery
I spent my uni years learning business fundamentals first—communication, KPIs, storytelling. Now, I'm fully learning the tools. SQL project breakdown after this. Late nights matter. Discipline matters. Let's keep building. 💪 #DataAnalytics #PowerQuery #DataWithDanny
csvでもxlsxでも、読込時は「ファイルから読込」ではなく「フォルダから読込」にするようにしている でもそれを普通にやるとヘルパークエリ作成されるので、例え複数ファイルを結合したくなくてもヘルパークエリなしになるようにして。 【メリット】 パス変更時のメンテナンス性が高まる #PowerQuery
いくら使いまわすことが非常に多いとはいえ、たかだが100行程度のデータで #PowerQuery でいろんなデータ引っ張ってきて加工・整形しまくって土台作ってるの、自分でやっててめっちゃバカバカしい。。。
「#PowerBI は楽しい」、めっちゃ分かります！心躍りますよね。 でもうちでは #M365 を導入してるのに、PowerBIどころか #PowerQuery の認知度すら低く……PQでマージしまくってデータ加工し、外部送信時はPQ削除するという方法をとっております。リレーション組むだけでいいのになーとよく思います
Power BIは楽しい、だんだんわかってきました。Power BIにはまるとFabricの世界につながるのですね。 参考サイトありがとうございます！
🚀 Most people skip this one step in Power Query… and it costs them cleaner reports & smarter dashboards! 😬 Learn how to build a Dynamic Calendar Table that updates automatically — no DAX, no hassle. 📅⚡ 🎥 Watch now → youtu.be/Yas8W6UbB-Q #PowerQuery #PowerBI #Excel
youtube.com
YouTube
🚀 Create a Dynamic Calendar Table in Power Query — The Ultimate Step...
In this Monkey Shorts, I explore a technique to fix non-aligned data issues in #PowerQuery. 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 help solve it for others: youtube.com/watch?v=TC_gRj…
youtube.com
YouTube
Shift non-aligned Columns in Power Query - Monkey Shorts Episode 045
A student was unsure of how to handle a scenario. So @kpuls showed how to manually build a custom function in #PowerQuery – complete with a sample transform to update the query – for 2 worksheet variations. Add a little bit of conditional logic, and we’re off to the races! 🐎
マージ処理・展開したら、元データと行順が崩れることがあるのに初めて直面した。。。何これ。 いちいちマージ前にインデックス追加して、展開後にそのインデックスをソートするしか解決策思いつかない。。。 #PowerQuery #助けてExcel #助けてPowerQuery
ここ1週間くらい #PowerQuery ＋ピボットテーブルで頑張って作り上げた経理報告があるんだけど……検算用に別アプローチ(手作業＋ピボット)で作成したら、1時間程度でできちゃった…地味に悲しい。 PQの方は、他予算でも使い回しが効くよう作ったとはいえ…
After the Microsoft Fabric Conference, there's a feeling Power Query may have finally turned a corner. With improvements in cost-effectiveness and ease of use, it may be time to revisit dataflows and give them another look. #PowerQuery #MicrosoftFabric youtube.com/watch?v=sC1B5s…
7/ Using Power Query made data cleaning and dashboard updates effortless, helping transform raw data into clear, actionable insights! #DataAnalytics #PowerQuery #Dashboard #ChurnAnalysis
youtu.be/0tUFlYKbE8E Transforma un simple archivo CSV en un dashboard profesional en Excel. Aprende paso a paso a conectar tus datos con Power Query. #dashboardenexcel #powerquery #exceldesdecero #analisisdedatosexcel #sergiobazo #lernencapacitaciones
youtube.com
YouTube
De archivo CSV a Dashboard en Excel: ¡Mira lo que lograremos paso a...
Hey Fam👋🏻 As a student of @VephlaUni I decided to analyze the What's app Group Chat Engagements of My fellow compatriots 😂 in cohort 8B and this is what I came up with using #Excel #Powerquery #Pivotcharts Beautiful isn't it?? Tell me what you think in the comments section.
Hey #DataFam 🫢 A 4-Year January Sales Overview (2018–2021) filtered by business segment. From Power Query ➡️ Power Pivot ➡️ DAX ➡️ Pivot Tables = Excel magic. No VBA. No add-ins. Just pure Excel. Thanks y’all for the support always 🫶❤️ #Excel #PowerQuery #DAX #Dashboard
#PowerQuery Update: you can now create a full date table in Power Query without writing M code for some columns again. UI make it easier 😌🎉 #PowerQueryEverything #PowerBI #DataTransformation
Something went wrong.
Something went wrong.
United States Trends
- 1. Columbus 119K posts
- 2. #WWERaw 48K posts
- 3. Middle East 204K posts
- 4. #IndigenousPeoplesDay 7,688 posts
- 5. Seth 42.4K posts
- 6. $BURU N/A
- 7. Thanksgiving 49.9K posts
- 8. Darius Smith 2,697 posts
- 9. Marc 41.7K posts
- 10. Mike Shildt 1,370 posts
- 11. Macron 189K posts
- 12. #IDontWantToOverreactBUT 1,228 posts
- 13. Apple TV 3,857 posts
- 14. Egypt 211K posts
- 15. Flip 50.2K posts
- 16. THANK YOU PRESIDENT TRUMP 61.4K posts
- 17. #SwiftDay 10.1K posts
- 18. The Vision 93.4K posts
- 19. HAZBINTOOZ 1,617 posts
- 20. #LightningStrikes N/A