cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## P&L calculation in Finance income report

Hi,

I am working on a P&L Finance income report, below is my report

The report has Revenue and Expense with many sub categories.

My requirement is to sum up the values of these sub categories and calculate "EBITDA" = Revenue - Expense

I have already calculated this EBITDA it is working fine for all categories except YTD categories as shown below

For some reason the highlighted values are showing wrong and I could'nt figure out why

YTD Actual = Rev(211,133) - Exp(-226723)= 15590 but 70,499 is thevalues Power BI is populating.

I dont understand this behaviour of Power BI where all values are correct except these totals.

2 REPLIES 2
Super User

@Anonymous,

Would you post your measures so we can review the DAX?

Proud to be a Super User!

Anonymous
Not applicable

Hello,

Thank you for the response below are the DAX I used

YTD Actual = -TOTALYTD([Total\$],Append1[Date].[Date])/1000
YTD Actual PY = -TOTALYTD([Total\$],SAMEPERIODLASTYEAR(Append1[Date].[Date]))/1000
YTD Actual vs Budget = [YTD Actual] - [YTD Budget]
YTD Budget = TOTALYTD([Budget],Append1[Date].[Date])
Total\$ = sum(Append1[AMT_ACTUAL])
Append1 is my table
Please check these DAX and let me know if i am wrong

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors