Data Cornering

by Janis Sturis April 14, 2021 Comments0

DAX Power BI

Calculate last or previous value within Power BI

Here is how to calculate last, previous, or values other periods ago in Power BI using DAX measures. It is not always straightforward,…

by Janis Sturis April 13, 2021 Comments0

DAX Power BI

Create group index column by using DAX

One way to create a group index by using DAX is with the function RANKX. How to do that depends on your dataset…

by Janis Sturis April 9, 2021 Comments0

Power BI

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…

by Janis Sturis April 6, 2021 Comments0

DataViz Power BI

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…

by Janis Sturis April 6, 2021 Comments0

DataViz 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…

by Janis Sturis March 31, 2021 Comments0

DataViz Power BI

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…

by Janis Sturis March 30, 2021 Comments0

Power BI

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.

by Janis Sturis March 17, 2021 Comments0

Power BI

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…

by Janis Sturis February 22, 2021 Comments0

Excel From Excel To R

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…

by Janis Sturis February 19, 2021 Comments0

R

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…