accumulated sum per quarter

[DanCasSan]

Hello partners,

I have a matrix, where it shows amounts by concept per year and quarter; however, I need each quarter to show me the accumulated, as shown in the attached image. At the top is the formula to calculate the quantities.

Thank you!

Reggards,

DC

[Syndicate_Admin]

Hello! Could you give me the solution to this case? What formula to use? I have the same case as I need to present

[amitchandak]

@DanCasSan , Is these trim 1, trim2 are your Qtr? Do you only want total to be cumalative or rows too ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[aj1973]

Hi @DanCasSan 

You will need to apply the TOTALQTD formula to your measure and for that you will also need a Calendar date to apply the Time intelligence formula accuraltly.

[DanCasSan]

Hello @aj1973 ,

I have tried the indicated formula, but I have the same result.

Reggards,

DC

[aj1973 · Accepted solution]

Well I don't know your Model nor how you are using the formula so I am going to speculate one more time and ask you to use TOTALYTD instead. 

Or maybe sharing a sample of your PIBx can help me better. 

[DanCasSan]

The latter has worked. Thank you!