How to do it...

To implement this recipe, perform the following steps:

1. Create the following measures:

Opening Balance = OPENINGBALANCEMONTH(SUM('R01_Sales'[Value]),'R01_Calendar'[Date])

Closing Balance = CLOSINGBALANCEMONTH(SUM('R01_Sales'[Value]),'R01_Calendar'[Date])

Month to Date = TOTALMTD(SUM('R01_Sales'[Value]),'R01_Calendar'[Date])

Previous Month = TOTALMTD(SUM('R01_Sales'[Value]),PREVIOUSMONTH('R01_Calendar'[Date]))

Year to Date = TOTALYTD(SUM('R01_Sales'[Value]),'R01_Calendar'[Date])

Previous Year = TOTALYTD(SUM('R01_Sales'[Value]),PREVIOUSYEAR('R01_Calendar'[Date]))

2. Create a Table visualization and place the Date column from the R01_Sales table, as well as all of the measures created in Step 1, in the Values field for this visualization.
3. Create a Matrix visualization and place the Year column from the R01_Sales table in the Rows field.
4. In the same Matrix visualization, place the Month column from the R01_Sales table in the Rows field underneath the Year column.
5. In the same Matrix visualization, place all of the measures created in Step 1 in the Values field.