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