Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative sum with condition

Hello   This is my situation :    Date Amount Condition Cumulative if Condition = Y 01-01-18 0   0 01-02-18 0   0 01-03-18 0   0 01-04-18 0   0 01-05-18 0   0 ...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create a calculated column first:

    New Amount = IF('Table'[Condition]="N",0,'Table'[Amount])

    Then try this measure:

    Measure = CALCULATE(SUM('Table'[New Amount]),FILTER(ALLSELECTED('Table'),'Table'[Date]<=MAX('Table'[Date])))

    The result shows:

    Here is my test pbix file:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Try like

Cumm Sales = CALCULATE(SUM(Table[Amount]),filter(date,date[date] <=max(Table[ Date])),Table[Condition]="Y")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

     

    Thanks for your help,

     

    When i try your measure, i receive an error... Are you sure with your syntax?