Getting ready

To prepare for this recipe, do the following:

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

R10_Table = 
    ADDCOLUMNS(
        GENERATESERIES(DATE(2016,1,1),TODAY()),
        "Inventory",RANDBETWEEN(10000,30000)
    )

This table represents inventory amounts per day. With this data, we wish to display average inventory levels summarized by week in the current quarter and by year, and by quarter for dates that are not in the current quarter.