How to add two custom rows in the matrix table of power bi ?

[Roshan_201295]

Hi 

I have problem with matrix table because I want to add two rows at bottom and top of matrix table of powerbi so please how can add it.I have this table in my powerbi but I want to add two more rows in  that table.

Afer that I want below kind of table.

That closing and opening will be calculated based on parameters values in inside month columns values like A-B+C for each month so please let me know how make it dynamic ?

[AnamPatel]

You can use the Table Visual in Power BI and create measures for Opening and Closing.

[Roshan_201295]

Yes but It should be dynamic ,I have used that but as month is going to increase that will not gonna dynamic for me

[amitchandak]

@Roshan_201295 , One of the workaround is discussed here

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