Forum Discussion
Get date from string
Hello, I have a string in the below format Im trying to get from and to dates in 2 separate column's in DAX but no luck. and Any one have idea, how to deal with this. ...
Anonymous
Add two columns: Change the data type to Date once you have added the columns.
Date1 =
LEFT('Table'[String],SEARCH("-",'Table'[String])-1)Date2 =
RIGHT('Table'[String],SEARCH("-",'Table'[String])-1)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂