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.

[TomMartens]

Hey,

the DAX function FORMAT(..., "<your format>") returns a value or creates a column of the data type text:
https://dax.guide/format/

This site

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

describes some of the limitations if you use a live connection (I deduct this from: you explicitly mention SSAS).

I'm think you have to change the format in your SSAS database.

Regards,

Tom

[Anonymous]

Hi rajulshah,

Change the type of your date column from Text to ShortDate in Properties and then apply format in your dax expression.

Regards,

Pradeep