Matrix custom subtotal

[cbold]

Hello,

I have a matrix which is filtered on page level by current year. The Rows are displaying various measures like profit last year, profit target current year and actual profit current year...  I put "MonthNameShort" from my date table into the columns to show those measures per month for the current year, which is working fine. 

What I would need is a extra column to show a cumulative total for each row, but only until year to month -1. Is this possible?

[v-lili6-msft · Accepted solution]

Hi@ cbold 

We can’t  add the Custom column into matrix . may be you could try to add the total into a table and align to the matrix.

you could post your new idea in Power BI ideas and make this feature coming sooner .

Best Regards,

Lin