How to do it...

To implement this recipe, do the following:

1. Create a new column in the R06_Table table using the following formula:

Periodic Revenue = 
    VAR __Month = 'R06_Table'[Month]
    VAR __Year = 'R06_Table'[Year]
    VAR __Revenue = 'R06_Table'[Revenue YTD]
    VAR __LastMonthRevenue = 
        CALCULATE(
            SUM('R06_Table'[Revenue YTD]),
            FILTER(
                ALL('R06_Table'),
                'R06_Table'[Month]= __Month - 1 
                    && 'R06_Table'[Year] = __Year
            )
        )
RETURN
    __Revenue - __LastMonthRevenue