Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
2 years ago
Solved

Copy 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

Data Protection
Need Help
Tips and Tricks
Tutorial Requests
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Heinrich , Try creating a calulated column using below dax

     

    FormattedDateTimeMeasure = FORMAT(MAX([YourDateTimeColumn]), "dd.MM.yyyy HH:mm")

2 Replies