Forum Discussion

theglamgamer's avatar
theglamgamer
Regular Visitor
3 years ago
Solved

convert date text to data type date using DAX

Having issue converting this date text to data type date:     Feb 3, 2021 12:00:00 EST I tried using Date Format = DATEVALUE and  DATEVALUE(FORMAT(Details[Plugin Modification Date],"MMM/DD/YYYY...
  • tamerj1's avatar
    tamerj1
    3 years ago

    theglamgamer 

    Column = CONVERT ( LEFT ( 'Table'[Date], 12 ), DATETIME )

     

     

    Also DATEVALUE + LEFT should work

    Column = DATEVALUE ( LEFT ( 'Table'[Date], 12 ) )

     

     

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi theglamgamer 

please try CONVERT - DATETIME. otherwise it will be complex 😅

  • theglamgamer's avatar
    theglamgamer
    Regular Visitor
    3 years ago

    Can you share an example? 🙂

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      theglamgamer 

      Column = CONVERT ( LEFT ( 'Table'[Date], 12 ), DATETIME )

       

       

      Also DATEVALUE + LEFT should work

      Column = DATEVALUE ( LEFT ( 'Table'[Date], 12 ) )