Forum Discussion
Solved
Rolling Dates
I have dax measue that works but I beleive the dates are static and would need to be manually updated for the next months. I need the dates to automatically change; From: DATE(2022,05,01), DATE(2023...
Sorry, I misread your starting date, it is in 2022 so that would look like this which makes more sense.
2023 Inforce = VAR _Start = EOMONTH ( TODAY(), -13 ) + 1 VAR _End = EOMONTH ( TODAY(), -1 ) RETURN CALCULATE ( COUNTA ( 'AISCVGP'[ACCUS#] ), AISCVGP[ACSTA] = "ACT", DATESBETWEEN ( 'Calendar'[Date], _Start, _End ) )
Sorry, I misread your starting date, it is in 2022 so that would look like this which makes more sense.
2023 Inforce =
VAR _Start = EOMONTH ( TODAY(), -13 ) + 1
VAR _End = EOMONTH ( TODAY(), -1 )
RETURN
CALCULATE (
COUNTA ( 'AISCVGP'[ACCUS#] ),
AISCVGP[ACSTA] = "ACT",
DATESBETWEEN ( 'Calendar'[Date], _Start, _End )
)
That worked! Thank you very much. I need to learn how to use the "VAR" dax code! Very helpful!