Month: July 2021
How to get previous or next record in R
Here are two methods how to get the previous or next record in the R data frame. One of them is better in large data frames, but the other is more compact.
How to calculate age in R
Here is how to calculate age in R in a way that humans understand it. If someone has a birthday on 2000-01-01 and today is 2021-07-09, then that person is 21 years old.
Correct age calculation in Power Query
It is not so easy to do age calculation in Power Query in a way that works all the time correctly. There are useful transformations that calculate age, but in specific situations, it is not working properly.
How to connect to Power BI dataset with Excel
Here is one of the easiest ways to connect to the Power BI dataset with Excel to use it in PivotTable. First of all, you or other users should have access to the dataset. If you are the owner of the dataset, then that is not a problem but might be necessary for others.