Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @rajulshah ,
We can make the calculated column sorted by your date key column.
Regards,
Frank
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |