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? Thanks!

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

2 Replies

  • 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")
    ))
  • Anonymous's avatar
    Anonymous
    Not applicable
    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") )