switch does not support comparing values of type true/false with values of type date

[humam85]

Hi ,
i tiried to use the folllowing formula in calucleted column to get "Yes" when dates in column (start) , fall between tow values ,
 but  i get an error 
"switch does not support comparing values of type true/false with values of type date, try to use format .... "
my dax :
Look Ahead Activity =

       SWITCH(

    TRUE(),

            DATESBETWEEN(

          'Updates'[Start],min('Updates'[Remaining Early Start]) ,min('Updates'[Remaining Early Start]) + 40

     ),"Yes",

      DATESBETWEEN(

          'Updates'[Finish],min('Updates'[Remaining Early Start]) ,min('Updates'[Remaining Early Start]) + 40

     ),"Yes",

             "No")

[FreemanZ · Accepted solution]

hi @humam85

try like:
Look Ahead Activity =
VAR _start = min('Updates'[Remaining Early Start])
RETURN
SWITCH(
    TRUE(),
    OR(
        'Updates'[Start]>= _start
            &&'Updates'[Start]<= _start + 40,
        'Updates'[Finish]>= _start
            &&'Updates'[Finish]<= _start + 40
     ),
    "Yes",
    "No"
)

[humam85]

@FreemanZ 

[FreemanZ · Accepted solution]

hi @humam85

try like:
Look Ahead Activity =
VAR _start = min('Updates'[Remaining Early Start])
RETURN
SWITCH(
    TRUE(),
    OR(
        'Updates'[Start]>= _start
            &&'Updates'[Start]<= _start + 40,
        'Updates'[Finish]>= _start
            &&'Updates'[Finish]<= _start + 40
     ),
    "Yes",
    "No"
)

[humam85]

thanks for quick  reply ...
it works well
if i want to put a specific date  as 1/12/2022 rather than  /min (remaining date)/ 
in wich format can i put it inside my dax

[FreemanZ · Accepted solution]

hi @humam85 

try like:

Look Ahead Activity =
VAR _start = DATE(2022,1,12)
RETURN
SWITCH(
    TRUE(),
    OR(
        'Updates'[Start]>= _start
            &&'Updates'[Start]<= _start + 40,
        'Updates'[Finish]>= _start
            &&'Updates'[Finish]<= _start + 40
     ),
    "Yes",
    "No"
)