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 made the following (easy) measure to get the wanted 12:
How do I get the same measure for a month?
5 Replies
Ilse_ScpDt , Assume this is a measure: PM_Needed_Present
A measure like
Maxx(Values(DIM_Calendar[DutchDayName]),[PM_Needed_Present])
Thanks for the reply.
I am not looking for the maximum value, but trying to sum all values of the seperate days. For the week I can use the measures above. But how would it work for a month?
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] )
