Expression to calculate Hours worked over a month

Jaros · 06-24-2021 05:44 AM

Hi Community, hope everyone is good today.

I have a question,

I am trying to build out an attendance register for a company that pays its wages once a month on the 15th of the month.

I have an Expression to calculate a weeks total hours, but lost when I need to try and get that to work across each month.

This is my formula for a particular week.

SUM(
SELECT(TimeCard[Calculated Time],
AND(
[WeekNum]=[_THISROW].[WeekNum],
[Year]=[_THISROW].[Year]
)
)
)

Any ideas?

1minManager

Jaros

Thanks I saw this and read it but because I need to divide it in the middle of a month(At the 15th) so I thought getting the Week expression and somehow extrapolating that would be a better solution but I’m not sure now

Steve

Maybe this?

SUM(
  SELECT(
    TimeCard[Calculated Time],
    AND(
      ([date] >= (EOMONTH(TODAY(), -2) + 15)),
      ([date] < (EOMONTH(TODAY(), -1) + 15))
    )
  )
)

Replacing date with the name of the column that contains the timecard date.