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.
Thanks.
I've tried to use calculate with dateadd, parallelperiod, previous quarter, etc and none of it worked.
enter image description here