I want to create a measure with 2 conditions based on days

[Saqibmughal00]

Hi Experts,

I am required to create a measure for calculating number of people from hours spent. the challenge is every day is 10.5 hours except friday which is 7.6 hours. How do I specify that in my measure?

My current measure is straight forward

No Of Labor = SUM(Database[HoursWorked]) / VALUE(10.5)

Any Help would be appreciated and thanks in advance.

[Saqibmughal00]

This worked but reduced my other days numbers.

My Equation:

the equation you provided:

[wdx223_Daniel]

No Of Labor = SUM(Database[HoursWorked]) / (VALUE(10.5)-IF(WEEKDAY(MAX(Database[Work Date]),2)=5,2.9,0))

[wdx223_Daniel]

No Of Labor = DIVIDE(SUM(Database[HoursWorked]) ,10.5-IF(WEEKDAY(MAX(Table[Date]),2)=5,2.9,0))

[Saqibmughal00]

Thanks but still not able to understand. This is how my table looks like, and how will I put 7.6 hrs condition then?

[wdx223_Daniel]

No Of Labor = SUMX(SUMMARIZE(Database,Database[HoursWorked],Database[Work Date),DIVIDE(Database[HoursWorked] ,10.5-IF(WEEKDAY(Database[Work Date],2)=5,2.9,0)))