Forum Discussion
Heinrich
Post Partisan
Post PartisanCopy Time Column to new Column and Reformat
Hello
I would like to duplicate a column that is formated "Time" to another column in "Text" format.
It worked but instead of having dd.mm.yyyy hh:ss it displays this mm.dd.yyyy hh:ss am/pm.
How can I format it to text that displays dd.mm.yyyy hh:ss?
Reason is that the 1st column is only showing date and no time
Thank you
Heinrich
Heinrich , Try creating a calulated column using below dax
FormattedDateTimeMeasure = FORMAT(MAX([YourDateTimeColumn]), "dd.MM.yyyy HH:mm")
2 Replies
- bhanu_gautam
Super User
Heinrich , Try creating a calulated column using below dax
FormattedDateTimeMeasure = FORMAT(MAX([YourDateTimeColumn]), "dd.MM.yyyy HH:mm")
HeinrichHello bhanu_gautam
Thank you very much
Juan