Forum Discussion

New Member

1 year ago

Solved

Additional calculation row in matrix

Is there a way to add a line item labeled "Calculation" which takes the ("Total Sales" + "Operating Costs")/"Operating Costs" for each year?

maruthisp
1 year ago
Hi Gingy2217,

Please find the attached pbix file with your solution implemented.
Additional calculation row in matrix.pbix

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!

Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X

Icon for Super User rank

Super User

1 year ago

You cannot assign a value to a row that doesn't exist so that extra row must exist first in your table. Please check out this tutorial. A link to a sample pbix is in the video description. https://youtu.be/R5fCJP6x03Y