Forum Discussion
Solved
Text Date Value Conversion
I have a date value that is stored in text format 'DD.MM.YYYY' whenever I try to convert it to date format using the DATEVALUE I get an error. I'm not that experienced in DAX, can anyone help?
Hi, Mayadah
Please try calculated columns as below:
New Date = SUBSTITUTE('Table'[Date],".","/")Result = DATEVALUE('Table'[New Date])Best Regards,
Community Support Team _ Eason
3 Replies
Hi,
cannot help you more, just check the help on Datevalue
Hi, Mayadah
Please try calculated columns as below:
New Date = SUBSTITUTE('Table'[Date],".","/")Result = DATEVALUE('Table'[New Date])Best Regards,
Community Support Team _ EasonThanks! it worked
