Convert Full Date/ Time Stamp to date in separate column in BI Desktop

[Humanoidhuman]

Hi,

I have an automated flow which downloads and saves my excel sheet to a predefined location on a daily basis. I have connected the excel file to my BI desktop and I am trying to build reports. 

However, the issue that I am facing is the date column looks like this 

I am trying to create a new column which will contain only the date (as the time is not as relevant for my report at this point). I tried using this

but to no avail. 

If anyone can kindly help me out with this, it would be highly appreciated!!

[Humanoidhuman · Accepted solution]

I managed to figure out a solution, although I did it in two steps. Maybe someone might know an easier way. However, still putting my method here for reference. First I created a column with the following DAX code

Date Only = LEFT('Table'[Date], FIND(" ", 'Table'[Date]) - 1)

This gave me dates in the following format 

In order to make it a bit more concise, I then converted the long date into short date format using another columna and the following DAX code:

Date Numeric = FORMAT('Table'[Date Only], "MM-DD-YYYY").

[Daoud_H]

Hi @Humanoidhuman,

You should remove the letters at the end by doing this : 

Date_2 = 
VAR New_Date = LEFT('Table'[date], LEN('Table'[date]) - 3)
VAR UTC_Date = FORMAT(New_Date, "mm/dd/yyy")
Return UTC_Date

This would work after that.

[Humanoidhuman]

Thanks so much @Daoud_H . I tried this. However, this basically just took out the timezone. Now it is displaying as