Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Expected Output
I need all help I can get please.
Thanks.
Solved! Go to Solution.
Hi @oolamide85
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
Hi @oolamide85
You may create measures for them. Here is the sample file for your reference.
Regards,
Cherie
Hi @oolamide85
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
good easy to understand
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
{"Salaries","Other Overheads"}
)
)
-[GrossProfit]
Hi @oolamide85
You may create measures for them. Here is the sample file for your reference.
Regards,
Cherie
How can I have the report visual dipslayed in the format below?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |