Create A Measure to Look At Hours Less Than A Certain Number of Hours

[DMB90]

I am looking to make time sheet reporting more dynamic. I want to be able to create a formula to say the following:

If total hours per person for each week are less than 35 hours, then make every line item for a person for that specific week say "Less than 35 Hours" if not "Total Hours Acceptable" as people don't need to work exactly 40 hours per week, but shouldn't be below 35.

I attached some sample data as well.

[rajendraongole1 · Accepted solution]

Hi @DMB90  - create a below calculated column in power bi  .

Status =

VAR TotalHours =

    CALCULATE(

        SUM('Test'[Hours]),

        FILTER('Test',

            'Test'[Name] = EARLIER('Test'[Name]) &&

            'Test'[Week] = EARLIER('Test'[Week])

        )

    )

RETURN

    IF(TotalHours < 35, "Less than 35 Hours", "Total Hours Acceptable")

Hope this helps .

[DMB90]

This worked! Thank you.