Change date format in SSAS

[rajulshah]

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.

[v-frfei-msft]

Hi @rajulshah ,

We can make the calculated column sorted by your date key column.

Regards,

Frank

[rajulshah]

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.