Forum Discussion
Add Calculated Row PowerBi Matrix
Hi atowriss1 ,
Do you want to some customized rows in the matrix to show % of OPEX and EBITDA? If yes, you can refer the following links to get it:
Display original values and their difference in the same table
If the above one can't help you get the desired result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share another simplified pbix file with detailed requirement. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
atowriss1 , I usually add a dummy account in the account table and the force calculation for for that values
Example
Switch(Max(Table[Account]) ,
"Ebita",[Ebita measure],
[Measure]
)
refer
Some other alternative
Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg
Thanks, but my data isn't that complex. I simply have 1 line each for Sales,Opex and EBITDA. No account numbers, as what I pulled is from aP&L in another tool. The transactional data isn't in PBI.
