cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Income Statement

What is the best way to set up an income statement view in power bi.

 

Is there any income statement visual available already or do I need to build this up? I want to see it with subtotals along the way. So and example could be:

 

Sales                     xxxxx

Cost of Sales        (xxxxx)

Gross Profit            xxxx

Fixed Costs            (xxxx)

Salaries                  (xxxx)

Opex                      (xxxx)

Operating Profit     xxxxx

Other income          xxxx

Profit before tax      xxxx

Tax                           (xxx)

Net Profit                xxxx

 

 

Something like that.

 

Thank you for your help

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hi @AhmedJ,

 

There is no such a visual to directly show income statement currently. You may have to generate measures/calculated columns to get desired result.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Hi @AhmedJ,

 

There is no such a visual to directly show income statement currently. You may have to generate measures/calculated columns to get desired result.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors