Forum Discussion

MrBertie's avatar
MrBertie
Regular Visitor
9 years ago

Convert Monthly Cumulative (Running) Total to Monthly Absolute Totals

I have a dataset with monthly cumulative totals for all financial columns.  Is there an easy way to convert the cumulative total in one column into an absolute monthly total instead?   (Yes, I have...
Need Help
kateshepardphd's avatar
kateshepardphd
Advocate I
3 years ago

I had to modify the formula -- maybe this will help someone:

Absolute =
VAR MonthSpent = TableName[Date].[MonthNo]
RETURN
    CALCULATE (
        MIN(TableName[CumulativeColumn])
            - CALCULATE (
                MIN(TableName[CumulativeColumn]),
                ALL ( TableName ),
                TableName[Date].[MonthNo]
                    = MonthSpent - 1
            )
    )