|
Hi , How are you doing? Before I get into this week’s video, I wanted to quickly tell you about something special I’m running for Black Friday. I’ve put together Goodly Insider – a single place where you get access to all my in-depth Power BI content, along with support and a community you can actually learn with. If you like the way I teach on YouTube and in my courses, this is the “all-in” version of that. I’ve explained more about Goodly Insider in this short video… you’ve got to watch it.
If I summarise it, as a Goodly Insider member, you get:
Normally, Goodly Insider is $499 for 12 months, but right now you can join for $399 (Indian students ₹23,990) + taxes, but only for 2 more days. After that, it goes back to the regular price.
Now back to this week’s video This week, I’ve got something that every Power Query user needs. If you’ve ever struggled to clean messy data or wondered which M functions are actually worth learning, this video is for you. I walk through some of my favorite Power Query functions, the ones that help you pull data from folders, transform columns dynamically, and create new calculated columns without endless steps. These are the functions that make Power Query feel more natural and help you tackle real-world data challenges more smoothly. Watch the video here.
A safer way to combine tables in PQ
Instead of expanding tables (which locks in column names), use
See all columns without scrolling! Instead of scrolling sideways to check columns, click the row header and view the whole row as a record. It’s a much easier way to look at wide tables.
Here are some small moments outside of Power BI… Nothing much...Mom said sit, so I sat |
