Forum Discussion

ernum's avatar
ernum
Frequent Visitor
3 years ago
Solved

Text to Date Column with Measures

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,

Need Help
Tips and Tricks
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    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!!

     

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    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!!