Text to Date Column with Measures

[ernum]

Hello all,

I have a date column as "Text" format as following and I need to use this data in the slicer. But first of all, I need to create a hierarchy and split "Day" - "Month" - "Year" and "Quarter"

My data column seems like that in the "Data Sidebar" and I want to convert second one with Hierarchy.

from  

to 

But I can't use data transformation because of I don't have access the data storage server. That's why, I can just use add new column with measure.

Can I solve this problem using "New Measure, New Column"? Can I separate the dates? If yes, how can I do it?

Thank you,

[Kishore_KVN · Accepted solution]

Hello @ernum 

Here is the solution. Use 'LEFT' DAX function to extract date in new column and then change the new column datatype to Date.

Column DAX looks like this:

Date = LEFT(Sheet1[OpenedAt],10)

Output looks like this:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[ernum]

Hello @Kishore_KVN 

Thanks a lot! It works..