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'

 
 
Steps:
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