A union of curiosity and data science

Knowledgebase and brain dump of a database engineer

Format SSAS Dates from '1900-01-01 00:00:00.000' to '01/01/1900'

1. Add a Varchar Date to your Data Source View
go into your data source view
right click on your date tables header
create a new named calculation
make a new varchar date
2. In your date Dimenision, Add your new field as the NameColumn on your datetime field.
Find the date you want to change

View it's properties
 Change the namecolumn field , add your new field.

Add comment