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