Need help - Table summations

[Dutch]

I have a power pivot table with the following data:

Company code      Financial Item    Buisness Unit  Period     Amount

123                           ABC                        A                  1           100

123                           ABC                        A                  2           245

234                           ABC                        A                  1             75

345                           CDE                        B                  2           125

234                           CDE                        A                  3           375

In an additional column I show the amount of the previous period, so I can calculate the change between periods (for specific company code, financial item and Business unit).

How do I do this in powerpivot?

Thank you for your help

Robert

[Phil_Seamark · Accepted solution]

HI @Dutch

Does this work?

Column = 
    SUMX(
        FILTER(
            'Table1',
            'Table1'[Company Code] = EARLIER('Table1'[Company Code]) &&
            'Table1'[Financial Item] = EARLIER('Table1'[Financial Item]) && 
            'Table1'[Business Unit] = EARLIER('Table1'[Business Unit]) &&
            'Table1'[Period] = EARLIER('Table1'[Period]) - 1
            ),
            'Table1'[Amount])