Cumulative Total for each Quarter

[tulasi_pbi1988]

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

[Anonymous · Accepted solution]

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]

Hi @tulasi_pbi1988 ,

Was this solutions useful? 

~ Tejaswi

[tulasi_pbi1988]

Hi @Anonymous ,

Thank You,

Yes, it is useful.