Forum Discussion

omelei86's avatar
omelei86
Frequent Visitor
6 years ago

Help! - Index cumulative sum

Hi 

I have 4 columns in my table 'Revenue': 

 

  • Customer number
  • Year
  • Month 
  • Revenue

 

I have created a line chart showing the cumulative revenue per month by using this measure:

 

 

Revenue **bleep** = 
CALCULATE( SUM(Revenue[revenue] ); FILTER( ALL ( Revenue[Month] ); Revenue[Month] <= MAX( Revenue[Month])))

 

 


Now I'd like to display a line chart showing the index between 2018 cumulative and 2019 cumulative. 

Hope you could help me out, 

 

Best, Matt

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You could make 2 new calculated measures and add another filter to the Calculate formula for 'Revenue'[Year] = "2018" . . . "2019" 

     

    Let me know how this works!

    • omelei86's avatar
      omelei86
      Frequent Visitor
      6 years ago

      Thanks Anonymous 

       

      I am new to DAX so could you please help me creating my new measure(s)?

       

      Thanks..

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        For 2018...

         

        2018 Revenue =
        CALCULATE( SUM(Revenue[revenue] ); FILTER( ALL ( Revenue[Month] ); Revenue[Month] <= MAX( Revenue[Month])), Revenue[Year] = 2018)

         

        For 2019...

         

        2019 Revenue =
        CALCULATE( SUM(Revenue[revenue] ); FILTER( ALL ( Revenue[Month] ); Revenue[Month] <= MAX( Revenue[Month])), Revenue[Year] = 2019)

         

        Or as one your could do...

         

        2019 minus 2018 Revenue = 

        CALCULATE( SUM(Revenue[revenue] ); FILTER( ALL ( Revenue[Month] ); Revenue[Month] <= MAX( Revenue[Month])), Revenue[Year] = 2019) - CALCULATE( SUM(Revenue[revenue] ); FILTER( ALL ( Revenue[Month] ); Revenue[Month] <= MAX( Revenue[Month])), Revenue[Year] = 2018)