Work Days times Hours per Person From the First Date until Today and Aggregated into All people.

[paulcar]

Im pulling my hair out trying to find out how this works.

Basically I want a Card that will say how much Work hours we have in a certain range (using a slicer) with all of our people, considering that people come in in random times of the month.

So 1 weekday (no holidays) = 8 hours per person.

Im trying to add up the workhours from the day a person started working up until today.

So when I click on the person, i will see his her maximum work hours for the range I have set with the slicer, and it should adjust up to the day.

I have this:
Date table with switched weekdays into 8names of the people and the day they came in

I tried this:

MaxHours =

CALCULATE(

SUM('Date'[8WorkHours]),

DATESBETWEEN('Date'[Date],FIRSTDATE('EDITOR CLIENT DATA'[DATE]),TODAY()))

But the total is not right. And its not a card. I would like to show a version where the accumulated total is shown and when you highlight a name/names, those particulars would add up.

Help.

[v-yulgu-msft · Accepted solution]

Hi @paulcar ,

Create an extra measure to sum up Max Hours for all available editors.

MaxHours = 
CALCULATE(
SUM('Date'[8WorkHours]),
DATESBETWEEN('Date'[Date],FIRSTDATE('EDITOR CLIENT DATA'[DATE]),TODAY()))

Total MaxHours = SUMX('EDITOR CLIENT DATA',[MaxHours])

Best regards,

Yuliana Gu

[Greg_Deckler]

Seems like a standard running total, there is a built-in quick measure for that. Just use your Work Hours click the ellipses and say New quick measure