Forum Discussion
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 "Qua...
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!!
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!!
Hello Kishore_KVN
Thanks a lot! It works..