ISINSCOPE Not Returning Date

[kboud3]

I'm creating this matrix and when I use the ISINSCOPE function to return a date value, it is resulting in a number.

The numbers are supposed to match the date next to it. In theory I would remove the Earliest Base Start Date and keep the Base Start Testing column in. 

This is my formula:

[FreemanZ · Accepted solution]

hi @kboud3 ,

try like:

measure = 

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

[v-xingshen-msft · Accepted solution]

Hi All,
Firstly FreemanZ thank you for your solution!
And @kboud3,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.

[FreemanZ · Accepted solution]

hi @kboud3 ,

try like:

measure = 

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