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 0...
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

     

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