How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
Latest Posts
How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
How to animate Excel chart in PowerPoint
Data visualizations are a great way to present your data, but sometimes you need to add some animation effects in PowerPoint to make…
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…
Reader PicksAll posts
How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
How to animate Excel chart in PowerPoint
Data visualizations are a great way to present your data, but sometimes you need to add some animation effects in PowerPoint to make…
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…