R Script Error "object not found"

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:

DAX: POISSON.DIST

R:

data.frame

poisson.test

Best Regards
Maggie

Community 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.