Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum Cummulative

Hello, i want to do a cummulative sum on the measure % diff portefeuille, but it dosent work for some reason. Here my formulas. I start by calculating the sum of my gain/lost with the mesure  Montan...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a measure like

     

    Calculate(sumx('Calendrier W/O'[Date]),[% diff portefeuille]),
    FILTER (
    ALLSELECTED( ( 'Calendrier W/O' )),
    'Calendrier W/O'[Date] <= MAX ( ( 'Calendrier W/O'[Date] ) )
    )
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try a measure like

 

Calculate(sumx('Calendrier W/O'[Date]),[% diff portefeuille]),
FILTER (
ALLSELECTED( ( 'Calendrier W/O' )),
'Calendrier W/O'[Date] <= MAX ( ( 'Calendrier W/O'[Date] ) )
)
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the help !!