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 cumu...
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

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi tulasi_pbi1988 ,

 

Was this solutions useful? 

 

~ Tejaswi

 

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

    Hi Anonymous ,

     

    Thank You,

    Yes, it is useful.