My Power Query Book in Russian
Here is a quick update for my Russian friends and colleagues. My book "Power Query в Excel и Power BI: сбор, объединение и...
Category: Power Query
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...
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...
Automatically remove empty columns and rows from a table in Power BI
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns...
With Reza Rad on Data Quality Automation
I had the pleasure speaking with Reza Rad on his YouTube live session. Watch out the recording and learn how to harness Power Query and dataflows as a...
New Recording: Power Query at Italy PUG
I was recently invited to speak about Power Query at Italy Power BI User Group. It was fun. Here is the...
New Recording: Low-Code Data Quality Automation
Last week I was invited to speak at Stuttgart Power BI User Group and shared my thoughts on Low-Code Data Quality Automation using Power Query. During the...
Optimized COVID-19 Report on AppSource
Following my last tutorial, I have updated the COVID-19 Power BI app on AppSource (download it here) and added incremental confirmed cases and deaths columns...
From cumulative numbers to increments
In this tutorial, we will learn how to convert cumulative numbers to incremental values using Power Query. In one of our earlier COVID-19 tutorials here, we...
Business Impact of Power Query – Survey Results
2020 was a tough year, but Power Query users have prevailed. A few weeks ago I published this survey to assess the business impact of Power Query. The results...
