How to calculate moving average or sum in Power BI
A moving average can help to see data insights that sometimes are a little bit hidden behind seasonality. Here is how to calculate…
Latest Posts
How to calculate moving average or sum in Power BI
A moving average can help to see data insights that sometimes are a little bit hidden behind seasonality. Here is how to calculate…
How to highlight one line chart series among many in Power BI
If you have multiple line chart series in one chart, then here is how to highlight one series among many in Power BI…
2 ways how to create separate Power BI charts with synchronized Y-axis
It is a great way to compare different data series if you create separate Power BI charts with a synchronized Y-axis. By using…
How to create a dynamic histogram in Power BI with adjustable bins
Here is how to create a dynamic histogram in Power BI. It changes with the help of a slicer that regulates data distribution…
4 ways how to organize DAX measures in Power BI
Here are my favorite ways to organize DAX measures in Power BI that can save plenty of your time in larger projects.
How to create simple near real time dashboard in Power BI
Here is how to create a simple near real time Power BI dashboard that will work without extra costs or complicated authorization. The…
Day of the week number in R
There is R base function like weekdays that can return the name of the weekday. But what if you want to get the…
Use ifelse across a range of R data frame columns
Here is how to apply the ifelse function across a range of multiple R data frame columns. Sometimes it is necessary to do…
ISO week number and ISO year in R
The easiest way to do ISO week number and ISO year calculations in R is by using two simple functions from package lubridate.
Variance or other calculation across columns in R
Here is how to calculate variance across columns in the R data frame. The same technique can be useful in other situations. Like…
Reader PicksAll posts
How to calculate moving average or sum in Power BI
A moving average can help to see data insights that sometimes are a little bit hidden behind seasonality. Here is how to calculate…
How to highlight one line chart series among many in Power BI
If you have multiple line chart series in one chart, then here is how to highlight one series among many in Power BI…
2 ways how to create separate Power BI charts with synchronized Y-axis
It is a great way to compare different data series if you create separate Power BI charts with a synchronized Y-axis. By using…
How to create a dynamic histogram in Power BI with adjustable bins
Here is how to create a dynamic histogram in Power BI. It changes with the help of a slicer that regulates data distribution…
4 ways how to organize DAX measures in Power BI
Here are my favorite ways to organize DAX measures in Power BI that can save plenty of your time in larger projects.
How to create simple near real time dashboard in Power BI
Here is how to create a simple near real time Power BI dashboard that will work without extra costs or complicated authorization. The…
Day of the week number in R
There is R base function like weekdays that can return the name of the weekday. But what if you want to get the…
Use ifelse across a range of R data frame columns
Here is how to apply the ifelse function across a range of multiple R data frame columns. Sometimes it is necessary to do…
ISO week number and ISO year in R
The easiest way to do ISO week number and ISO year calculations in R is by using two simple functions from package lubridate.
Variance or other calculation across columns in R
Here is how to calculate variance across columns in the R data frame. The same technique can be useful in other situations. Like…