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...
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,...
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...
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...
Snapshot analysis for your Power Apps Analytical Dataflows
Two new apps in a week! I am doubling down on Microsoft AppSource. Earlier this week I released here the Dataflow Snapshots Analysis free app to monitor the...
