How to change the datatype of a column from string/text to Datetype in tabular editor
I have date column in string/text. i need to change that into datetime so that i can split that into Year and month to create hierarchy for a visual. I need to use tabular editor. The dataset i am using is in direct query mode. I couldnt direct change the datatype of that column in tabilar editor. i got error. when i try the following calculated column, CONVERT(Values('Query2'[CreationDate]), DateTime) in visual i am getting the following error and data is not populating. Anyone please suggest how to correct this.