Date showing format instead of date

[Anonymous]

Hi there,

I've created a dax statement that returns a date given a that a has filtered down to 1 row. However, when it returns, it displays a format rather than an actual date. I'm trying to display this on a card - when use the date as a field on the card alone it displays fine.

Here is the dax code below, any thoughts on what might be wrong?

Disp_DateOrCount_explore = VAR countTitle = count(SharkTankRegister[Title])
RETURN
IF(countTitle=1, MIN(SharkTankRegister[Date Implemented]), countTitle & " Sharktanks Presented")

[amitchandak · Accepted solution]

@Anonymous , This will become text data type measure, should display date

try like

Disp_DateOrCount_explore = VAR countTitle = count(SharkTankRegister[Title])
RETURN
IF(countTitle=1, format(MIN(SharkTankRegister[Date Implemented]),"MM/DD/YYYY"), countTitle & " Sharktanks Presented")

change format as per need

[Anonymous]

Solved! Using FORMAT() function seems to fix it