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…
How to add markers to line chart in Power BI
Like step chart option previous post it is also a little bit hidden. The key is to use categorical X axis. After that,…
How to create a step chart in Power BI
It is a little bit hidden option, but very simple to use. After creating your line chart, go to the Format section ->…
How to schedule or periodically loop tasks in Windows
For scheduling in Windows, there are classy options like Task Scheduler and running programmes on startup. Also, it worth mention that you can…
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…