Forum

How to add calculat...
 
Notifications
Clear all

How to add calculated rows in Power BI

5 Posts
2 Users
0 Reactions
71 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I would like to add EBITDA and Net result rows etc in Power BI visualization.

Can you please let me know how to add them without effecting the total.

Thank you

Regards,

Aye

 
Posted : 25/04/2020 1:44 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

Turn off the Subtotals in the Table formatting pane and create your own using measures. It's the only way.

Mynda

P.S. In future, can you please save the image on its own and upload it, rather than embedding it inside a Word document. This will make it quicker for us to view and a smaller file being uploaded to our forum. Thanks!

 
Posted : 25/04/2020 6:02 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Thanks, Mynda.

If I use measure, as far as I know it will only create columns. I just want Rows like Gross Profit, EBIDTA, EBIDTA after recharge and Net Results between the data.

Thank you

Regards

Aye

 
Posted : 26/04/2020 8:08 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye, 

This is outside the scope of the course. Hopefully this post will point you in the right direction.

Mynda

 
Posted : 27/04/2020 6:16 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Mynda,

If I do all the category ( Revenue, Operating Expense, EBIDTA, Depre&Amor, EBIT, Net Result) as measure and make them on for "show on rows", would it be fine?

Please let me know of your thoughts.

thank you.

Regards,

Aye

 
Posted : 01/05/2020 5:01 am
Share: