Create a table based on R

[Anonymous]

Hello everybody,

So I am having an issue with R in Power BI because in the R script visual function. I can only put one table in each visual because the amount of rows are different. So in R I created a table that made it so all of the values within a month is summed up using this formula:

newtable <- dataset %>%
mutate(month = month(dataset$DATE, label = TRUE), year = year(dataset$DATE)) %>%
group_by(year, month) %>%
summarise(total.amt = sum(AMOUNT))

This would make it so they have the same amount of rows.

Now I want to make that formula into a table in Power BI. Is this possible?

I saw elsewhere to use a SUMMARIZE function but I am not familiar with how you would put an R script into it.

Thanks

[v-cherch-msft · Accepted solution]

Hi @Anonymous

Find some articles for you to check if they would help you.

https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

https://www.thebiccountant.com/2017/08/25/tips-and-tricks-for-r-scripts-in-the-query-editor-in-power-bi/

Regards,
Cherie