Sum values in a column for each staff every month

[nicholas_]

Hi,

How do I create a column to sum up the values if the Day and Night count for individual staff for each month.

The end goal is to have a column with the day and night counts combined.

Raw Data:

End Goal:

Thank you.

Nic

[FreemanZ · Accepted solution]

hi @nicholas_ 

try to add a calculated column like:

Column =
SUMX(
FILTER(
data,
data[Staff]=EARLIER(data[Staff])
&&data[Date]=EARLIER(data[Date])
),
data[Days]
)

it worked like: