Forum Discussion
How to convert text data to Date
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? ...
that worked. thanks.. 🙂
I did the formula above and is getting me error:
the EOS Date column has values as such below:
rajendraongole1
Super User
Super UserHi Anonymous - 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!!
that worked. thanks.. 🙂