Forum Discussion
rajulshah
7 years agoResident Rockstar
Change date format in SSAS
Hello,
I want my date columns in dd/MM/yyyy format in SSAS.
As I format the column using the following dax, it's data type is changed to "Text".
Date = FORMAT(Date[dates],"dd/MM/yyyy")
But, I am unable to filter and sort after doing the above transformation.
Please guide me further on how to have format as dd/MM/yyyy and also should be filtered and sort by date.
Thanks in advance.
2 Replies
- v-frfei-msftCommunity Support
- rajulshahResident Rockstar
Hello v-frfei-msft ,
We are fetching data from SSAS, hence this option wouldn't help in solving my issue. Live Connection doesn't allow me modelling in the report.