@skillwave.trainingFinal 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.socialThese 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
@goatshipmate.bsky.socialMicrosoft 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.
@goatshipmate.bsky.socialOoh. 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?
@excelguru.caIn 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.training#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.socialI 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.
@excelguru.caIn 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
@skillwave.trainingTransform 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
@excelguru.caWhat 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!
@chinarelliti.bsky.social🚨 **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:
@skillwave.trainingHere, @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...
@excelguru.caWhen you first open Query Sleuth in our Monkey Tools #Excel Add-in, you’ll notice the queries are colour coded with up to 4 different colours: 🟠🟡🔵🟢 This adds a bit of extra insight around the query load destinations. Learn more at mkyt.ca/querysleuth
@excelguru.caWe had an awesome time at last week's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates went over some of the newest updates to Power BI, and then Melissa De Korte presented a deep dive into #PowerQuery for solving more advanced text-splitting challenges.
🎦 www.youtube.com/watch?v=yH6Z...
@skillwave.trainingHere's a must-know #PowerQuery technique to unpivot data easily in #Excel (and #PowerBI). 🙌 @excelguru.ca shows how to convert a human-friendly report layout into a clean tabular format that works beautifully for #PivotTables and #BusinessIntelligence: www.youtube.com/watch?v=KKKZ...
@mikhail-mikushin.bsky.socialHow to use Python in Power Query transformation #data #dataanalytics #Python #PowerQuery #PythonTransform
@excelguru.caEver discovered errors in your data after unpivoting? 😬 Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which contained errors? 😉 Join me to find out: www.youtube.com/watch?v=sJaX...
@skillwave.trainingSubscribing to the "Ask Ken Anything" sessions is like having a personal consultant on call for just a fraction of the cost! ☎️ Join @excelguru.ca for his live, interactive support calls held twice each month for personalized help with #Excel, #PowerQuery, #DAX and more.
Sign up at skw-t.com/aka
@skillwave.trainingEver discovered errors in your data after unpivoting? 😬 Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which contained errors? 😉 Join @excelguru.ca to find out: www.youtube.com/watch?v=sJaX...
@excelguru.caToday's Vancouver #PowerBI and Modern #Excel meet-up gets underway at 12pm. 🕛 Joseph Yeates will first show us some of the latest and greatest in Power BI. Then, Microsoft MVP Melissa de Korte will explore cool ways to split our data using #PowerQuery. 🤓
RSVP here: www.meetup.com/vancouver-po...