R Code Loop - For each Customer

[LillyLegenda]

Hi all,

I have a question about running a market basked analysis in R on a filtered dataset.

My dataset contains Invoice Number, Position, Article and SoldToAccount.

I would like to run the R code for each SoldToAccountNr indivdually and add it in a new column to the result to later compare them.

So the end result should look like this were I can see the customer number.

Do you think this is possible?

File: https://filebin.net/hqdd2woqyifqytl9

Thank you very much in advance. 🙂

[v-yangliu-msft]

Hi  @LillyLegenda  ,

This is a link to related content, I hope it will help you:

https://community.powerbi.com/t5/Desktop/Run-R-Script-to-create-new-column/m-p/784924

https://stackoverflow.com/questions/56962583/how-to-add-column-in-power-bi-by-run-r-script-in-query-...

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-r-in-query-editor

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-r-scripts-in-power-bi...

Best Regards,

Liu Yang

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