ISINSCOPE Not Returning Date

hi Anonymous ,

try like:

measure = 

FORMAT(SWITCH(...), "mm/dd/yyyy")

Hi All,
Firstly FreemanZ thank you for your solution!
And Anonymous,I tried to modify your code a little bit hope it helps!

Base Start Testing = 
SWITCH(
    TRUE(),
    ISINSCOPE('Query'[ActivityName]), BLANK(),
    ISINSCOPE('Query'[Merged]), FORMAT(FIRSTDATE('Query'[Date]),"MM-DD-YYYY"),
    ISINSCOPE('Query'[Division]), BLANK(),
    BLANK()
)

Base Start Testing(copy) = 
SWITCH(
    TRUE(),
    ISINSCOPE('Query'[ActivityName]), BLANK(),
    ISINSCOPE('Query'[Merged]), CONVERT(FIRSTDATE('Query'[Date]),STRING),
    ISINSCOPE('Query'[Division]), BLANK(),
    BLANK()
)

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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