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.
the DAX function FORMAT(..., "<your format>") returns a value or creates a column of the data type text:
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.