Forum Discussion

Dutch's avatar
Dutch
Regular Visitor
8 years ago
Solved

Need help - Table summations

I have a power pivot table with the following data:   Company code      Financial Item    Buisness Unit  Period     Amount 123                           ABC                        A               ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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])
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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])