Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX FORMAT() date/time formatting problem

I have a datetime column (table Issues, column CREATED) which I want to display (in a table visual) in this format:    'dd/mm/yy h:nn AM/PM'. Following the documentation of the FORMAT funcrion, I c...
Need Help
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

Have you tried selecting the datetime column --> Column Tools and in format box copy/paste your desired format

dd/mm/yyyy h:nn AMPM

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks, but as I mentioned earlier, this cannot be done since this column is a measure, so when in the data view, the format of the measure is locked to Text and cannot be changed.

    Just to re-iterate, the whole purpose of this measure is to dynamically invoke the FORMAT() function which takes the format from another column in another table.