topic Re: DAX Calculating Day and Month in DAX Commands and Tips

DAX Calculating Day and Month

Urielpc — Mon, 28 Mar 2022 08:41:44 GMT

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

Re: DAX Calculating Day and Month

johnt75 — Mon, 28 Mar 2022 09:03:22 GMT

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 )

Re: DAX Calculating Day and Month

CNENFRNL — Mon, 28 Mar 2022 10:06:07 GMT

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

Re: DAX Calculating Day and Month

Anonymous — Thu, 31 Mar 2022 02:12:34 GMT

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.

Re: DAX Calculating Day and Month

Urielpc — Sun, 03 Apr 2022 13:30:46 GMT

Thanks CNENFENL

Looks good.