Forum Discussion
Sum month for all dates
Dear platform, I have a measure that is always showing the MAX value. So if you group the days to a week you won't get 2+3+2+3+2 but you get the Max (in this case not 12 but 99). I mad...
FYI, you can use an iterator to sum over the days:
PM_Needed_Present_week =
VAR _Days =
FILTER (
VALUES ( DIM_Calendar[DutchDayName] ),
DIM_Calendar[DutchDayName] IN { "Maandag", "Dinsdag", "Woensdag", "Donderdag", "Vrijdag" }
)
RETURN
SUMX ( _Days, [PM_Needed_Present] )If you want to sum over all days, then you can just write:
PM_Needed_Present_week =
SUMX (
VALUES ( DIM_Calendar[DutchDayName] ),
[PM_Needed_Present]
)
Thanks a lot! Also something I was looking for.
How would this work for the sum over a month instead of a week?
Same syntax but replace the day columns with the month column.
For example:
PM_Needed_Present_week = VAR _Months = FILTER ( VALUES ( DIM_Calendar[DutchMonthName] ), DIM_Calendar[DutchMonthName] IN { "mei", "juni", "juli" } ) RETURN SUMX ( _Months, [PM_Needed_Present] )