Forum Discussion
Date table + Matrix Column Deader = DDD, D MMM
Hello everyone! I am trying to make my tables a little fancy and running into an issue.
I am using a Dax built date table, and loking to change the Date format to something like Thu, 3 Jan.
The problem is that I cant see that option in the list... and I dont know how to add options to the Format list (if thats even possible!)
The Image below should help to explain what im talking about:
While the highlighted options would actually result in Wednesday 14 March, I would prefer the option to have them abbreviated if that is at all possible.
Would either of these be something thats possible with PBI atm? Or would this be a case that calls for a unique calculated column within the Date Table itself? I just cant help but think the Format option should work for something like this :smileyfrustrated:
Any help is much appreciated : )
hi, StefanM
You could use FORMAT Function to custom format of data.
https://docs.microsoft.com/en-us/dax/format-function-dax
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Note: Format Function converts a value to text according to the specified format.
So you could format the result or add a new column as a reference, do not use it for calculation
For example:
When you need use date for calculation, you still need to use Date instead of Column
Best Regards,
Lin
1 Reply
hi, StefanM
You could use FORMAT Function to custom format of data.
https://docs.microsoft.com/en-us/dax/format-function-dax
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Note: Format Function converts a value to text according to the specified format.
So you could format the result or add a new column as a reference, do not use it for calculation
For example:
When you need use date for calculation, you still need to use Date instead of Column
Best Regards,
Lin