Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
3 years ago
Solved

Date Formatting

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?...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago
    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's avatar
Anonymous
Not applicable
3 years ago

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")
))