Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

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?

Data Protection

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

Anonymous
2 years ago
that worked. thanks.. 🙂

4 Replies

rajendraongole1
Super User
2 years ago
Hi Anonymous -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!!
- Anonymous
  Not applicable
  2 years ago
  I did the formula above and is getting me error:
  
  the EOS Date column has values as such below:
  - rajendraongole1
    Super User
    2 years ago
    Hi 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!!