Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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-10T11:02:54.000-0300

2018-10-10T11:02:59.000-0300

2018-10-10T11:03:05.000-0300

I'd like to transform into date only using dax.

could you help me?

Thanks!!

Anonymous
7 years ago
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'