Forum Discussion

joshcomputer1's avatar
joshcomputer1
Icon for Helper V rankHelper V
7 years ago
Solved

Cumulative Total with duplicates

I need to create a calculated column like the yellow one below.  *This is a simplified view of the scenario. This cannot be a measure. What is does is it takes the Growth% for the month then adds it ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    You were pretty close, I think you want something like:

     

    Cumulative = 
VAR __table = SUMMARIZE(FILTER(ALL(Table15),[Date]<=EARLIER([Date])),[Date],"__growth%",MAX([Growth %]))
RETURN
SUMX(__table,[__growth%])

    See Table 15 of attached. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

You were pretty close, I think you want something like:

 

Cumulative = 
VAR __table = SUMMARIZE(FILTER(ALL(Table15),[Date]<=EARLIER([Date])),[Date],"__growth%",MAX([Growth %]))
RETURN
SUMX(__table,[__growth%])

See Table 15 of attached.