Forum Discussion
Ilse_ScpDt
Helper I
4 years agoSum 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...
amitchandak
Super User
4 years agoIlse_ScpDt , Assume this is a measure: PM_Needed_Present
A measure like
Maxx(Values(DIM_Calendar[DutchDayName]),[PM_Needed_Present])
Ilse_ScpDt
Helper I
4 years agoThanks 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?