Forum Discussion

Ilse_ScpDt's avatar
Ilse_ScpDt
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
Ilse_ScpDt's avatar
Ilse_ScpDt
Icon for Helper I rankHelper I
4 years ago

Thanks a lot! Also something I was looking for.

 

How would this work for the sum over a month instead of a week?

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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] )