Forum Discussion
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
Hey,
the DAX function FORMAT(..., "<your format>") returns a value or creates a column of the data type text:
https://dax.guide/format/
This sitehttps://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
