Forum Discussion

kaydee64's avatar
kaydee64
Frequent Visitor
2 years ago

New field calculation based on Matrix Sum

Hello,   I am currently creating a report to give employees an overview of their worked hours including overtime during the month. I would like to include a measure that is using the sum of my tab...
Need Help
DataInsights's avatar
DataInsights
Super User
2 years ago

kaydee64,

 

Try this measure:

 

Monthly Overtime = 
VAR vOvertime =
    SUM ( Hours[overtime] )
VAR vResult =
    IF ( vOvertime - 2 >= 2, vOvertime )
RETURN
    vResult