Forum Discussion
Analyze in Excel - Date field issue
When using 'Analyze in Excel' Date fields from my model show up in excel as text which really limits the usage of the Analyze in Excel functionality. Has anyone else encountered this and come up with...
In the data model you can do several workarounds:
- Use formaty YYYY-MM-DD, which numerically or alphabetically sorts correctly.
- Crerate a Delta-Days column, just today - date, creating a sortable integer value.
- Create a custom dates table with all the possible breakouts you could ever want, like quarter, Delta-Days, etc.