Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a…
Latest Posts
Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a…
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…
Reader PicksAll posts
Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a…
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…
Why i chose to use Grammarly
This article is a tribute to my assistant in writing without which I can no longer imagine doing it. English is not my…