Forum Discussion
Helper IIDate table + Matrix Column Deader = DDD, D MMM
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
Community Supporthi, 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