Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

Thanks

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    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 🙂

    YouTube  LinkedIn

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - Well, I would use split in Power Query on the hyphen, that would be easiest, but if you really want a DAX solution:

     

    From = DATEVALUE(MID([Column1],1,FIND("-",[Column1])-1))

To = DATEVALUE(MID([Column1],FIND("-",[Column1])+1,LEN([Column1])))

     

    PBIX is attached below sig, Table 24. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for Helping me.

      Unfortunately, it is with BLANK's in Dates Range causing the issue. The BLANK is taken care and now the DAX works well.

       

      Thank you