How to add leading zeros in R, Power Query, DAX or Excel
Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to…
How to combine Excel sheets with Power Query
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI.…
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when…
How to create a flexible calendar table with Power Query
Here is an example of how to generate calendar based on two input values – date of the first day and date of…
How to categorize and group data in time intervals with Power Query
If you have DateTime or time column in your data, then sometimes there is a desire to analyze it by time intervals. With…
Easy way how to make Power BI table from scratch, without an external data source
There are two options: – Power Query function #table – Enter Data feature in Power BI #table function, in my opinion, is a…
How to calculate ISO week number in Power Query
I calculated ISO week number in Power Query following instructions from Wikipedia. Here is how it goes. M code is at the end…
How to calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different…
How to get LiveChat API data with Microsoft Excel or Power BI
Here is an example with getting LiveChat transcripts right into Microsoft Excel Power Query or Power BI. Chat conversations are not the most…
How to generate date and time interval list using Power Query
One thing I love about Microsft Power Query is the ability to make lists. It means that you can generate data without some…