Run R Script to create new column

[Anonymous]

I am trying to create a new column ("pct_change") within an existing dataframe that was imported from SQLServer.

The following code worked in R Studio:

library(dplyr)

df1 <- df1 %>%
group_by(employeeid) %>%
arrange(fiscalyear, .by_group = TRUE) %>%
mutate(pct_change = ((Salary/lag(Salary) - 1) * 100))

I then modified the above code from "df1" to "dataset" but was unable to get it to work. Could someone please help me?

[Anonymous]

I'm just getting a blank table.

[Icey · Accepted solution]

Hi @Anonymous ,

I use the code below and new column is created.

library(stats)
library(base)
library(dplyr)
df1 <- dataset %>%
group_by(employeeid) %>%
arrange(fiscalyear, .by_group = TRUE) %>%
mutate(pct_change = ((Salary/lag(Salary) - 1) * 100))

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Riv]

 How and where did you save that code block within Power BI?

[Anonymous]

Thanks, Icey! I didn't realize you had to import R base and stats.

[Icey]

Hi @Anonymous ,

Can you give me your error information? So that I can help you better.

Best Regards,

Icey