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...
Category: Power Query
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...
The Impact of Power Query
Two years ago, I published a survey to measure the impact of Power Query. Since then, Power BI has gained tremendous momentum and accelerated the evolution of...
Import & Combine multiple PDF files from WHO
In the last tutorial of the COVID-19 dashboard series here, you learned how to import a single COVID-19 situation report directly from WHO website using Power...
