How to convert text data to Date

[gheecalipes25]

Hi,

Need some help. i have a column in the table (excel datasource) where the EOS date column has texts on it (N/A, Not Announced)? what would be the best dax formula approach for this one?

[rajendraongole1]

Hi @gheecalipes25 -create a calculated column that replaces the text values with a specific date

EOS Date Cleaned =
IF(
ISERROR(DATEVALUE([EOS date])),
BLANK(),
[EOS date]
)

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[gheecalipes25]

I did the formula above and is getting me error:

the EOS Date column has values as such below:

[rajendraongole1]

Hi @gheecalipes25 - Can you try below calculated column

EOS Date Cleaned =

VAR IsValidDate =

    NOT(ISERROR(DATEVALUE([EOS Date])))

RETURN

    IF(

        IsValidDate,

        DATEVALUE([EOS Date]),

        DATE(1900, 1, 1) // or BLANK() if you prefer

    )

with Blank()

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[gheecalipes25 · Accepted solution]

that worked. thanks.. 🙂