Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure to find the Cumulative Sum Values

Hi, I have two fields in my table. YYYY-MM which the year and month details. Due amount which has the due amount that is yet to come for respective year and month.   I need a Measure to find the Cu...
Need Help
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi ,

     

    Please try:

     

     

    Measure = SUMX(FILTER(ALLSELECTED('Table'),'Table'[YYYY-MM] <= MAX('Table'[YYYY-MM]) ),  'Table'[Due Amount])

     

     

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

Anonymous ,

a new column = sumx(filter(Table, [YYYY-MM] = earlier([YYYY-MM]) ),  [Due Amount])

 

 

a new measure= sumx(filter(allselected(Table), [YYYY-MM] = max([YYYY-MM]) ),  [Due Amount])