Forum Discussion
cheid1977
Advocate I
Advocate IIf Statement with two different data types
In the data set I have a column for delivery date. If there is no delivery date the source of the data enters "1/1/1900". I am trying to create a second column that leaves the cells blank if this dat...
I found that the solution is to go under "OPTIONS">Data Load, and uncheck "Automatically detect column types and headers for unstructured sources". This automatically converts everything to text and allows you to select the data type for each column.
Sean
Community Champion
Community ChampionJust a reminder although it DOES NOT apply to this question since this is only a comparison NOT a date calculation
the first officially supported date in DAX is March 1, 1900 (for date calculations)
cheid1977Advocate I
Advocate II found that the solution is to go under "OPTIONS">Data Load, and uncheck "Automatically detect column types and headers for unstructured sources". This automatically converts everything to text and allows you to select the data type for each column.