Date Formatting

[PowerBI123456]

Hi,

I have a different date formats that I am bringing over (column 1 below) in text, and need to convert them into the date format as shown in column 2 in power query:

Any suggestions? Thanks!

[Anonymous · Accepted solution]

Measure =

VAR _int =

    IFERROR (

        CONVERT ( MAX ( 'Table'[Column1] ), INTEGER ),

        MAX ( 'Table'[Column1] )

    )

RETURN

    IFERROR ( format(CONVERT ( _int, DATETIME ),"dd-mm-yyyy"), format(MAX ( 'Table'[Column1] ),"dd-mm-yyyy") )

[Anonymous]

this might be a start

Measure = IF (CONTAINSSTRING(selectedvalue('Table'[Column1]),"/") ,   FORMAT(  DATEVALUE(selectedvalue('Table'[Column1])), "mm/dd/yyyy"),

IF(CONTAINSSTRING(selectedvalue('Table'[Column1]),"-") ,    FORMAT(  DATEVALUE(selectedvalue('Table'[Column1])),"mm/dd/yyyy")

))