R Script Error "object not found"

[Anonymous]

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)

[v-juanli-msft · Accepted solution]

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.

[Anonymous]

mnay thanks Maggie. Excellent feedback as always. let me test.