Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Change date display format

 

Hi,

 

My Date is in format 01/09/2017 00:00:00 ie (DD/MM/YYYY hh:mm:ss) as below:

 

DataTime
01/09/2017 00:00:00
01/09/2017 00:30:00
01/09/2017 01:00:00
01/09/2017 01:30:00
01/09/2017 02:00:00
01/09/2017 02:30:00
 
 
 

 

 

but I want it to display like the below format:

 

Fri 01 02:30  ie (DDD DD hh:mm)

 

Expected Results:

DataTime
Fri 01 00:00
Fri 01 00:30
Fri 01 01:00
Fri 01 01:30
Fri 01 02:00
Fri 01 02:30

 

Please help

 

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Just add a column to your data with the following syntax:

     

    Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")

     

    Regards,

    MFelix

     

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Anonymous,

     

    Just add a column to your data with the following syntax:

     

    Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")

     

    Regards,

    MFelix

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you all for your tremendous help.

      Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")…..This simply worked in this instance:

      I truly appreciate all your contributions.

       

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    you can use this little DAX statement to create a calculated column

    Column with Display Value = FORMAT('Table2'[DatetoFormat],"DDD DD hh:mm")

    Please be aware, that creating a new column will have impact on filtering the rows of the table or all the related tables.

     

    It's not possible to change just the "display" format

     

    Hopefully this gets you started

     

    Regards

    Tom 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    You are going to have to create a new column that uses a combination of WEEKDAY, SWITCH, CONCATENATE and FORMAT functions.

     

    Something like:

     

    Column = var wday = WEEKDAY(Events[EventTime])
var wdayname = SWITCH(wday,1,"Sun ",2,"Mon ",3,"Tue ",4,"Wed ",5,"Thu ",6,"Fri ",7,"Sat ")
RETURN CONCATENATE(wdayname,FORMAT(Events[EventTime],"dd hh:mm"))

     

    Update: The other solutions work as well although not documented here:

    https://technet.microsoft.com/en-us/library/ee634398(v=sql.130).aspx

     

    I would disagree that it is not possible to just change the display format, you can do that in the Modeling tab by having a data type of Date/Time and changing the Format via the dropdown. But, there is no choice for your particular format.