DAX Calculating Day and Month

[Urielpc]

Hello,

i have to sum days along with month like this

         day,       sumByDay,   SumByMonth
01/01/2022       10,                    25
02/01/2022       12,                    25
03/01/2022        3 ,                    25
01/02/2022        9 ,                     11
02/02/2022        2 ,                     11

My problem is the filter context
when i use remove all
its give me all dates but i need only for that month
how can i achive that?

Thanks alot

[Urielpc]

Thanks CNENFENL

Looks good.

[Anonymous]

Hi @Urielpc ,

Please try:

Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),YEAR([Day])=YEAR(MAX('Table'[Day])) && MONTH([Day])=MONTH(MAX('Table'[Day]))))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL · Accepted solution]

A seemly simple solution, but the mechanism under the hood is complex enough.

[johnt75]

Make sure that you have a Year Month column on your date table then use

Sum by Month = 
var currentMonth = SELECTEDVALUE( 'Date'[Year Month])
return CALCULATE( [Base measure], REMOVEFILTERS('Date'), 'Date'[Year Month] = currentMonth )