Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Create a table called R01_Table using the following formula:

R01_Table = 
UNION(
    ADDCOLUMNS(
        GENERATESERIES(1,10000,1),
        "Page",
        "Product",
        "Step",
        1
    ),
    ADDCOLUMNS(
        GENERATESERIES(1,7000,1),
        "Page",
        "Add to Shopping Cart",
        "Step",
        2
    ),
    ADDCOLUMNS(
        GENERATESERIES(1,2000,1),
        "Page",
        "Payment",
         "Step",
        3
    ),
    ADDCOLUMNS(
        GENERATESERIES(1,1200,1),
        "Page",
        "Confirmation",
        "Step",
        4
    )
)