Forum Discussion
R Script Error "object not found"
Hi Experts
I am getting the following erro on this simple bit of R Script, canot see what i have done wrong (see image with error message below)
Sheet1 <- data.frame(PRIMARYTOOUTCOMEYEARS, OUTCOMETYPE) Sheet1 <- unique(Sheet1) time_tot <- (PRIMARYTOOUTCOMEYEARS) num_rev <- (OUTCOMETYPE) poisson.test(x=num_rev, T=time_tot, conf.level=0.95)
Hi Anonymous
As tested, you don't need to write this code again in the code editor.
Sheet1 <- data.frame(PRIMARYTOOUTCOMEYEARS, OUTCOMETYPE) Sheet1 <- unique(Sheet1)
From you code, it seems it will not plot a visual but calculate the Poisson distribution based on two columns "PRIMARYTOOUTCOMEYEARS, OUTCOMETYPE".
If my understanding is correct, you can run R script in Power Query.
In addition, there is a function in DAX, does it meet your scenario?
create a new column
Column = POISSON.DIST([PRIMARYTOOUTCOMEYEARS],[OUTCOMETYPE],0.95)
Reference:
R:
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
As tested, you don't need to write this code again in the code editor.
Sheet1 <- data.frame(PRIMARYTOOUTCOMEYEARS, OUTCOMETYPE) Sheet1 <- unique(Sheet1)
From you code, it seems it will not plot a visual but calculate the Poisson distribution based on two columns "PRIMARYTOOUTCOMEYEARS, OUTCOMETYPE".
If my understanding is correct, you can run R script in Power Query.
In addition, there is a function in DAX, does it meet your scenario?
create a new column
Column = POISSON.DIST([PRIMARYTOOUTCOMEYEARS],[OUTCOMETYPE],0.95)
Reference:
R:
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.