Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Create the following tables:

R10_K = 
    SELECTCOLUMNS(
        GENERATESERIES(1, 25, 1),
        "K",
        [Value]
    )

R10__k = 
    SELECTCOLUMNS(
        GENERATESERIES(1, 25, 1),
        "k",
        [Value]
    )

R10_N = 
    SELECTCOLUMNS(
        GENERATESERIES(1, 25, 1),
        "N",
        [Value]
    )

R10__n = 
    SELECTCOLUMNS(
        GENERATESERIES(1, 25, 1),
        "n",
        [Value]
    )

These four tables represent the inputs to our geometric distribution formula.