Forum Discussion

tulasi_pbi1988's avatar
tulasi_pbi1988
Icon for Helper I rankHelper I
7 years ago
Solved

Cumulative Total for each Quarter

Hello,

 

I need help to calculate Cumulative total for each quarter.

 

 

I had tried this measure 

cumm1 = TOTALQTD([Revenue$],'Calendar'[Date])
I need to quarter partition for cumulative sum means from next quarter starting date again cumulative need to start.
 
In the above image Date and Fiscal Quarter coming from the Date table and Revenue is from a different table.
 
Could anyone please help on this.
 
Thank You
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi tulasi_pbi1988 ,

     

    Try this calculated column.

     

    Cummulative = CALCULATE(
        SUM(Sheet7[Revenue]),
        FILTER(
            Sheet7,
            Sheet7[FY and Q]=EARLIER(Sheet7[FY and Q])
            && Sheet7[ Date] <= EARLIER(Sheet7[ Date]
            )
            ))

    Let me know if this works.

     

    Thanks,

    Tejaswi

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi tulasi_pbi1988 ,

     

    Try this calculated column.

     

    Cummulative = CALCULATE(
        SUM(Sheet7[Revenue]),
        FILTER(
            Sheet7,
            Sheet7[FY and Q]=EARLIER(Sheet7[FY and Q])
            && Sheet7[ Date] <= EARLIER(Sheet7[ Date]
            )
            ))

    Let me know if this works.

     

    Thanks,

    Tejaswi