Matrix Multiplication using the Cartesian product in Power Query
Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query...
Authoring a Power BI Dataflows Solution
Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring...
Introduction to Power BI Dataflows
For my first blog post I wanted to write about one of my favorite topics: Power BI Dataflows. If it’s the first time you read about this product or if...
Next Chapter
I have been quiet for a while and had a lot of thinking about my next chapter after leaving Avanade last August. Today, I would like to share with you a small...
My Power Query Book in Russian
Here is a quick update for my Russian friends and colleagues. My book "Power Query в Excel и Power BI: сбор, объединение и...
Handling Excel Formula Errors in Power Query
Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and...
A New Journey
This Friday was my last day at Avanade. It was an amazing journey for me and I would like to deeply thank many people at Avanade for the inspiration,...
Mailchimp App: New Features
This week we released a major update to the Mailchimp app on AppSource here and included 5 new report pages. Get latest version What's...
Power Query Magic with Wyn Hopkins
I had the honor to speak recently with Wyn Hopkins on his new podcast/YouTube channel - Power Query...
Convert “Column1” to “A”
I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI...
