Date table + Matrix Column Deader = DDD, D MMM

[StefanM]

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 

Any help is much appreciated : )

[v-lili6-msft · Accepted solution]

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