Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
7 years ago

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

    • rajulshah's avatar
      rajulshah
      Resident 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.