Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…
Archive
Category: Power Query
Quick Tips: Adding Leading Zero to Integer Values (Padding) with DAX and Power Query
There are some cases that we want to add a leading zero to a digit, such as showing 01 instead…
The Story of my Book, “Expert Data Modeling with Power BI”
In 2020, the world celebrated the new year with many uncertainties. Well, life is full of uncertainties, but, this one…
Integrating and Visualising Multiple Microsoft To Do Accounts with Power BI
It’s been a while that I use Microsoft To Do to organise my daily tasks. From work-related tasks to buy…