Forum Discussion

gorankocinski's avatar
gorankocinski
New Member
8 years ago
Solved

New column sum formula help

hi, I have one document with 2 tables in it. In the first table there are 2 columns  A with unic ID of some business and B with given funds by state. for example    Table name - GivenFunds ID,...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Greg_Deckler,

     

    In your scenario, have you created any relationship between the two tables? If not, please create one. Then you can try following calculated column:

     

    Column =
CALCULATE (
    SUM ( SecondTable[Cost] ),
    FILTER ( FirstTable, FirstTable[ID] = EARLIER ( FirstTable[ID] ) )
)

     

    And once you create the relationship Greg_Deckler's solution should not return errors.

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Greg_Deckler,

 

In your scenario, have you created any relationship between the two tables? If not, please create one. Then you can try following calculated column:

 

Column =
CALCULATE (
    SUM ( SecondTable[Cost] ),
    FILTER ( FirstTable, FirstTable[ID] = EARLIER ( FirstTable[ID] ) )
)

 

And once you create the relationship Greg_Deckler's solution should not return errors.

 

Thanks,
Xi Jin.

  • gorankocinski's avatar
    gorankocinski
    New Member
    8 years ago

    Tnx a lot.

    I have had relationships, but i was writing bad punctations. I was typing , instead of ;