cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

Dear All,

I would like to calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns,

Gross Profit = Turnover + Cost of Sales

EBITDA = Salaries + Other overheads - Gross Profit

Net profit = Non trading/exceptional + Depreciation + Tax - EBITDA

Below is my Sample data: Sample Data

Expected Output

Expected Output Month on Month

I need all help I can get please.

Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

You may refer to below measures. You may use TOTALYTD Function for YTD. Here is the document for you.

```Gross profit =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER ( 'Sample', 'Sample'[L1] IN { "Turnover", "Cost of Sales" } )
)```
```EBITDA =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER ( 'Sample', 'Sample'[L1] IN { "Salaries", "Other overheads" } )
)
- [Gross profit]```
```Net profit =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER (
'Sample',
'Sample'[L1] IN { "Non trading/exceptional", "Depreciation", "Tax" }
)
)
- [EBITDA]```

Regards,

Cherie

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

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

You may create measures for them. Here is the sample file for your reference.

Regards,

Cherie

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

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

You may refer to below measures. You may use TOTALYTD Function for YTD. Here is the document for you.

```Gross profit =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER ( 'Sample', 'Sample'[L1] IN { "Turnover", "Cost of Sales" } )
)```
```EBITDA =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER ( 'Sample', 'Sample'[L1] IN { "Salaries", "Other overheads" } )
)
- [Gross profit]```
```Net profit =
CALCULATE (
SUM ( 'Sample'[Value] ),
FILTER (
'Sample',
'Sample'[L1] IN { "Non trading/exceptional", "Depreciation", "Tax" }
)
)
- [EBITDA]```

Regards,

Cherie

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

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

Thanks for your help, Gross Profit works perfectly well but, am still having problem with the EBITDA below is the error message:

The value for 'GrossProfit' cannot be determined. Either 'GrossProfit' doesn't exist, or there is no current row for a column named 'GrossProfit'.

EBITDA=
CALCULATE
(
SUM
('Finance 2'[VALUE]),
FILTER('Finance 2','
Finance 2'[Level1] IN
)
)
-[GrossProfit]

Community Support Team

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

You may create measures for them. Here is the sample file for your reference.

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

How can I have the report visual dipslayed in the format below?

Frequent Visitor

## Re: Calculate Gross profit, EBITDA, Net Profit and YTD based on this two columns

good easy to understand