DAX Formula to Check if Text is in Date Format

rlmeyer — Wed, 06 Oct 2021 15:38:32 GMT

I am wanting to use a calcuated column to take a list of text from a software where the users enter in a date and then output a date for other fields in my dashboard. The software does not have the ability to force the user to only enter in the text in a date format. The user can leave the field blank, enter in text, etc.

The field the data is pulling from is (PropertiesList[Start Date]) and if the user left the field blank or input text that is not in date format, I want the calcuated column to use the date that the file was created (DataDetails[CreatedDate]).

Is there a way to use a formula to evaluate if the (PropertiesList[Start Date]) field has the text in a date format and if not use the (DataDetails[CreatedDate]) field?

Something along the lines of IF IS DATE or IF FORMAT is Date?

Re: DAX Formula to Check if Text is in Date Format

rlmeyer — Wed, 06 Oct 2021 16:07:43 GMT

I figured out a way to check this for my current dataset. A nested IF statment that checks for errors with a DateValue function and then checks for blank data.

Start Date =
IF(ISERROR(DATEVALUE(PropertiesList[Start Date])),
FORMAT(DataDetails[CreatedDate],"Short Date"),
IF(ISBLANK(PropertiesList[Start Date]),
FORMAT(DataDetails[CreatedDate],"Short Date"),
PropertiesList[Start Date]))

topic Re: DAX Formula to Check if Text is in Date Format in DAX Commands and Tips

DAX Formula to Check if Text is in Date Format

Re: DAX Formula to Check if Text is in Date Format