How to make Power BI line chart with accented last data point
Here is my approach on how to make Microsoft Power BI line chart with accented last data point. It is flexible and can…
dplyr error: column must have a unique name
In rare cases, the data source may contain multiple columns with the same name, and some of the next actions with dplyr functions…
How to rename data frame columns in R
Here are multiple ways how to rename columns in R.
Difference between DAX and Excel functions that looks the same
If you know Excel functions, it is easier for you in Power BI with DAX. Sometimes it is mentioned as an advantage. It…
R error in data.frame : undefined columns selected
For me, R error undefined columns selected appears when I try to select some of the columns to keep in the data frame.…
Convert R TRUE and FALSE values to 1 and 0, and vice versa
Here is a simple method to convert R TRUE and FALSE values to 1 and 0, and vice versa.
Convert TRUE and FALSE into 1 and 0 in Power BI
Here is a simple way how to convert TRUE and FALSE into 1 and 0 in Power BI. Precisely speaking – Power Query…
Convert TRUE and FALSE values to 1 and 0 in Excel
Here is a simple trick that is not so obvious. By adding two minus signs before calculation, you can convert TRUE, FALSE into…
Auto-detect R data frame column data types
Here is how to auto-detect and change data types for multiple columns in R at the same time.
How to identify outliers in Microsoft Power BI
One of the simplest methods that you can detect outliers in Power BI is visual detection and IQR method that is also used…