Accumulated sum per quarter

47 Views Asked by At

I've tried several ways to calculated the accumulated sum per quarter for the following table in Power BI, but I couldn't get the right results.

What I need is to sum the "% increase" column per quarter but resetting when the quarter changes.

Can anybody help me out with this?

I don't need the blank spaces as long as the results I get is per quarter.

enter image description here

Thanks.

I've tried to use calculate with dateadd, parallelperiod, previous quarter, etc and none of it worked.

1

There are 1 best solutions below

0
Vilmar On
Acc = 
CALCULATE (
    SUM ( Tabela[%] ),
    FILTER (
        ALL ( Tabela[Date] ),
        QUARTER ( Tabela[Date] )
            = ROUNDUP ( MONTH ( MAX ( Tabela[Date] ) ) / 3, 0 )
    )
)

enter image description here