When trying to use DAX to add a new claculated column to add a YEAR data column, I the following error:
============================Error Message:============================The end of the input was reached.The calculated column 'demo[CalculatedColumn1]' contains a syntax error. Provide a valid formula.============================Call Stack:============================ at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingTable.Update(UpdateOptions updateOptions) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.Update(UpdateOptions updateOptions) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.ChangeFormulas(IList`1 colIndices, IList`1 names, IList`1 expressions) at Microsoft.AnalysisServices.Modeler.ClientWindow.ChangeFormula(TableWidgetPanel currentTable, IList`1 colIndices, IList`1 names, IList`1 expressions, Boolean doFormulaBarCommit)============================</PRE>
If anyone can assist i would appreciate it.
Thanks,
NMSS!8
============================Error Message:============================The end of the input was reached.The calculated column 'demo[CalculatedColumn1]' contains a syntax error. Provide a valid formula.============================Call Stack:============================ at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingTable.Update(UpdateOptions updateOptions) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.Update(UpdateOptions updateOptions) at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.ChangeFormulas(IList`1 colIndices, IList`1 names, IList`1 expressions) at Microsoft.AnalysisServices.Modeler.ClientWindow.ChangeFormula(TableWidgetPanel currentTable, IList`1 colIndices, IList`1 names, IList`1 expressions, Boolean doFormulaBarCommit)============================</PRE>
If anyone can assist i would appreciate it.
Thanks,
NMSS!8