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.   ...
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
    5 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