Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
RD_PowerBI31
Frequent Visitor

Matrix report -sliced data substract

I need to substract hours from Reg hours column in Power BI. How can I achieve the Final hours calculation in power BI

 

 

EmployeeLeave TypeTrans hrsRegular Hrs
ABCSIck Leave840
ABCAnnual Leave640
ABCDH Leave440
XYZSIck Leave1240
XYZAnnual Leave1040
XYZDH Leave840

 

Report requiremnt as below. I am able to get the below report in matrix by placing Leave type in column section of Matrix view. But unable to do substract RH-total hrs.

 

EmployeeReg HrsSLALDHTotalFinal Hrs
ABC408641840-18
XYZ40121083040-30
3 REPLIES 3
Anonymous
Not applicable

If these are columns you can use SUM Function    Hrs = Sum('Table'[Hrs]) - Sum('Table'[Total Hrs])

Anonymous
Not applicable

You need to create a measure
Hrs = [Hrs] - [Total Hrs]

How do you pickup total hours, it will be generated dynamically. There is no column to hold total

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors