Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cumulative Total

Good morning People   I am struggling with a cumulative formula. The following formula calculates my total mass for each trading day perfectly. How do I convert it to a cumulative formula:   CALC...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    8 years ago

    Anonymous,

     

    For the cumulative sum, you could try with the DAX fomula in a new measure like:

    Cumulative Sum =
    CALCULATE (
        SUM ( Master[Mass(kg)]),
        FILTER (
            ALL ( Master[Trading Day],Master[Sales Year]),
            Master[Trading Day]<= MAXX ( FILTER ( Master, Master[Sales Year] = 2018 ), Master[Trading Day] )
              && Master[Sales Year] = 2017
        )
    )

    A sample result I got is like:

      

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

Anonymous,

 

For the cumulative sum, you could try with the DAX fomula in a new measure like:

Cumulative Sum =
CALCULATE (
    SUM ( Master[Mass(kg)]),
    FILTER (
        ALL ( Master[Trading Day],Master[Sales Year]),
        Master[Trading Day]<= MAXX ( FILTER ( Master, Master[Sales Year] = 2018 ), Master[Trading Day] )
          && Master[Sales Year] = 2017
    )
)

A sample result I got is like:

  

Regards,

Charlie Liao

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Perfect solution, thank you very much Charlie