Quick Q: Datesbetween with If statement

Hi Anonymous ,

Try with this code..

Measure =
IF (
    AND ( Table[Date] >= DATE ( 2021, 03, 09 ), Table[Date] <= DATE ( 2021, 03, 21 ) ),
    1,
    0
)

hi Anonymous try with below measure

Measure = IF (MAX('Table'[Date])>= DATE ( 2021, 03, 01 )&&MAX(Table[Date]) <= DATE ( 2021, 08, 31 ),1,0)

HI Anonymous,

You can also use the aggregate function to extract the current date and use the calendar function to generate the date range and use the 'in' operator to compare with them.

Measure =
VAR currDate =
    MAX ( Table[Date] )
VAR dateRange =
    CALENDAR ( DATE ( 2021, 03, 09 ), DATE ( 2021, 03, 21 ) )
RETURN
    IF ( currDate IN dateRange, 1, 0 )

Regards,

Xiaoxin Sheng