Miguel Escobar is the co-author of the original book on Power Query - "M" is for data monkey and its recent completely re-written version "Master Your Data"

Also a musician with his song Someday Somehow available to listen to

Wine Shop Owner, art lover, Power Query enthusiast.

YouTube version:  https://youtu.be/y5XV6-FXOKk

Filter a table based on another

LinkedIn: https://www.linkedin.com/in/eriksvensen/

Check out Rick's links Favourite Post https://gorilla.bi/power-query/list-functions/ Most popular https://gorilla.bi/dax/5-ways-to-calculate-last-12-months-in-dax/ And good news... Query collections are coming... https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/data-integration/save-curate-personal-query-collection-power-query LinkedIn: https://www.linkedin.com/in/rickmaurinus/ Twitter: https://twitter.com/Rickmaurinus

As always I thoroughly enjoyed chatting with my guest.  Thank you Celia.

https://youtu.be/JCNSVWY2NYw

https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/

And her most popular here

https://youtu.be/OQE9qMbofCw

https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/

You can also find Celia here:

https://www.linkedin.com/in/celiajordaoalves/

I'm a big fan of Chandeep's YouTube videos, his Power Query content is thoughtful and well explained.  I often discover he's covered topics 12 months before I do which is annoying! :)

I really enjoyed our wide-ranging chat.

Customisable Ribbon in Power Query

You can find Chandeep via his excellent YouTube channel https://www.youtube.com/c/GoodlyChandeep

Favourite Blog: Recruitment Dashboard in Power BI - https://www.goodly.co.in/recruitment-tracker-dashboard-template/

Most Popular: Combine Data from Multiple Excel Files - https://www.youtube.com/watch?v=_jegiQkyC3s

Find Chandeep here:

• Blog - https://www.goodly.co.in/blog/

"Just get it done" - the unofficial Power Query motto

Ed is a Principal Consultant at P3 Adaptive From life as a CPA to providing more than 1,000 solutions to the Power BI Community, Ed has been on the Power Query / Power Pivot / Power BI journey from the start.

Ed's post on the P3 blog about lists can be found here: https://p3adaptive.com/2022/03/working-with-lists-in-power-query-lets-count-words/

Favourite Blog: https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-query

Most Popular: https://www.ehansalytics.com/blog/2020/7/16/return-row-based-on-max-value-from-one-column-when-grouping

You can find Ed here https://www.linkedin.com/in/edhansberry/

and on twitter: https://twitter.com/ehansalytics

Miguel is Group Product Manager, Citizen Data Integration @ Microsoft

He has been on the Power Query development journey since it's early inception as codename Data Explorer, and was involved in the original development of the Power Query user interface that we all know and love.

He's now running the team and is more coach than player these days.

It was fantastic to chat to Miguel about all things Power Query and try out the new game - Just a "M"inute

You can find Miguel here https://www.linkedin.com/in/migllopis/   and check out all things Power Query via https://powerquery.microsoft.com/en-us/   and the relatively new twitter handle https://twitter.com/MSPowerQuery 

YouTube version: https://youtu.be/6GL4U4pkWeI

Imke has made a huge contribution already to the various tech community forums and continues to do so by now developing some amazing tools to make all our Power BI development lives easier.

https://www.thebiccountant.com/about/

Imke's favourite tool: Power BI Cleaner Gen2 now covers Analysis Services Models as well (thebiccountant.com)

Most popular article:  Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)

Advanced algorithms:

Goal seek algorithm: Non-linear Break-Even Analysis in PowerBI – The BIccountant

Matrix Inversion (MINVERSE Excel-function): Returns the inverse matrix for a matrix stored in an array. As a bonus, its determinant is returned in the metadata. (github.com)

Ben Gribaudo Series

Power Query M Primer (part 1): Introduction, Simple Expressions & let | Ben Gribaudo

The Power Query Magic YouTube version is available here... https://youtu.be/AWuWwxGs3lo

Alex Powers is a passionate Power Query advocate who has trained thousands of people in Power BI and now works for Microsoft helping to spread the word that Power Query is Magic!

We have a wide ranging conversation, agreeing that Tables are the key to it all. I raise my wariness of "AI" driven help, Alex battles with whether to restart a blog, and of course we discuss Query Folding.

30 Day Challenge: Query Folding - #30DQuery -

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

Power BI Workshops - https://aka.ms/pbiworkshops