Month: July 2019
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when you have to detect the first or last record in each group. Here is 2 solutions: group index with M language and group index with R.
Incomplete final line found on Rprofile.site when installing from GitHub
I was stumbling on this “incomplete final line found on Rprofile” error while installing d3rain package with the following code remotes::install_github(“daranzolin/d3rain”). In one of the previous post I was modifying my Rprofile.site file and there is definitely a connection with this error.
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 your storytelling better. Here is a fast and easy approach on how to animate an Excel chart in a few steps.