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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Please have a try.

Change the custom column in the Model.

 

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Polly,

    I forgot to mention a crucial detail: this column is a measure, as described in the blog post that I linked to in my question.

    It seems that measures cannot be formatted with the method you've described - the 'Format' is set to Text and cannot be changed.

     

    Here is the measure:

    CreatedRegional = 
    var formatter = SELECTEDVALUE('Date Formats'[Format])
    var source_date = SELECTEDVALUE(Issues[CREATED])
    RETURN
      FORMAT(source_date, formatter)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

      We really can't modify the type of measure. Please try to use column or you can create an idea here.

      Ideas (powerbi.com)

       

      Best Regards
      Community Support Team _ Polly

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.