Forum Discussion
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...
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)
Hi Anonymous ,
We really can't modify the type of measure. Please try to use column or you can create an idea here.
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.