Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Date format issue

    Posted Jul 01, 2022 08:05 AM
    Help please!
    I have converted dates to UK/European format (DD/MM/YYYY), which is working fine.
    I have a problem however when trying to calculate a column where it changes the format to US (MM/DD/YYYY). The calculated column is:

    PERIOD = ('table1'[START_DATE]) &"-"& ('table1'[FINAL_ENDDATE])

    File settings are UK English format.

    Has anyone else had this issue?

    ------------------------------
    Claire Cotton
    Data Manager
    ------------------------------


  • 2.  RE: Date format issue
    Best Answer

    Posted Jul 03, 2022 09:44 PM
    Não sei se entendi, mas veja se ajuda.

    PERIOD =
    FORMAT ( [START_DATE], "dd/mm/yyyy" ) & "-"
        & FORMAT ( [FINAL_ENDDATE], "dd/mm/yyyy" )​


    ------------------------------
    Vilmar Santos
    ------------------------------



  • 3.  RE: Date format issue

    Posted Jul 05, 2022 03:14 AM
    Thank you Vilmar, this worked!

    ------------------------------
    Claire Cotton
    Data Manager
    ------------------------------



  • 4.  RE: Date format issue

    Posted Jul 11, 2022 02:49 PM

    Hi Claire,

         'Has anyone else had this issue?'

    American format date is my nightmare :)

    Regards,



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------