topic Re: same months comparison over the years - DAX in DAX Commands and Tips

same months comparison over the years - DAX

RT6 — Tue, 09 Apr 2024 08:26:52 GMT

Hi all!

i use this DAX

CY = CALCULATE(SUM('Market'[Sales]), DATESMTD('Calendar'[Date]))/1000;

and for the last year

LY = CALCULATE(SUM('Market'[Sales]),DATESMTD(dateadd('Calendar'[Date],-1,YEAR)))/1000

the issue is when i select filter for example jan&feb 2024, it shows only value for February 2024 & 2023 accordingly. But i need a sum for of all selected months

Any suggestions?

Re: same months comparison over the years - DAX

Dangar332 — Tue, 09 Apr 2024 14:36:59 GMT

Hi, RT6

you have slicer in month form and you want sum of month wise then use DATESYTD()

use DATESYTD instead of DATESMTD

Re: same months comparison over the years - DAX

Anonymous — Wed, 10 Apr 2024 06:33:26 GMT

Hi RT6

Thanks for the reply from Dangar332 , please allow me to provide another insight:

My sample:

Create a measure as follows

comparison = VAR _previous = CALCULATE(SUM(Market[Sales]), FILTER(Market, [Date] IN SAMEPERIODLASTYEAR('Calendar'[Date]))) VAR _current = CALCULATE(SUM(Market[Sales]), FILTER(ALL(Market), [Date] IN VALUES('Calendar'[Date]))) RETURN DIVIDE(_previous + _current, 1000)

Result:

Best Regards,
Yulia Xu

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

Re: same months comparison over the years - DAX

RT6 — Wed, 10 Apr 2024 07:00:13 GMT

hi Yulia,

thanks for your response! SAMEPERIODLASTYEAR worked well in this case 🙂