topic Re: Sum values in a column for each staff every month in DAX Commands and Tips

Sum values in a column for each staff every month

nicholas_ — Fri, 28 Apr 2023 15:12:02 GMT

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 — Fri, 28 Apr 2023 15:28:32 GMT

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: