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") ...
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