Forum Discussion
DMB90
Helper II
Helper IICreate A Measure to Look At Hours Less Than A Certain Number of Hours
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.
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])))RETURNIF(TotalHours < 35, "Less than 35 Hours", "Total Hours Acceptable")Hope this helps .
2 Replies
- rajendraongole1
Super User
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])))RETURNIF(TotalHours < 35, "Less than 35 Hours", "Total Hours Acceptable")Hope this helps .
DMB90This worked! Thank you.