Forum Discussion
Dynamic DATEFunction
Hey sandee ,
if I understand it right the winter sales should just cover the sales in December, January and February, correct?
In this case I would just filter to these months. Check if the following measure would work:
Winter Sales = CALCULATE( [Sales Amount], MONTH( 'Date'[Date] ) IN { 12, 1, 2 } )Also be aware that your approach wouldn't cover February 29th in a leap year.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi Selimovd,
this is incredible, you made this DAX very easy , i was working on filter condition on ">= && "<=". and was trying to work on "Date" dax so that i can enter the proper format. but it was not accepting same.
Hey sandee ,
if I understand it right the winter sales should just cover the sales in December, January and February, correct?
In this case I would just filter to these months. Check if the following measure would work:
Winter Sales =
CALCULATE(
[Sales Amount],
MONTH( 'Date'[Date] )
IN {
12,
1,
2
}
)
Also be aware that your approach wouldn't cover February 29th in a leap year.