Forum Discussion
Text with (Date Time UTC) to Date
Hi guys, I've the following column: Resolutiondate 2018-10-29T21:09:54.000-0200 2018-10-29T21:10:01.000-0200 2018-10-10T11:02:44.000-0300 2018-10-10T11:02:49.000-0300 2018-10-10...
You can use that formula if you want to create a new formatted date column. If you are comfortable losing the timestamp you dont need DAX.
'Data' --> 'Modeling' --> 'Format' --> 'Date/Time'
=FORMAT(<value>, "MM-dd-YYYY")
Also you can refer to the links below for additional formatting options
https://docs.microsoft.com/en-us/dax/format-function-dax
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function