DAX error, fx function, year

[pinak.nubs]

Hello,

I bought Bill's book and trying to follow instructions given on page 25 and 26 but I get error message "the end of the input was reached"
can anyone help??






exact error message:-
============================
Error Message:
============================

The end of the input was reached.
The calculated column 'demointl[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)

 

[Derek Brown]

Hello again.
Yes, I get the same error - even after correcting the 'date problem' (http://www.mrexcel.com/forum/showthread.php?t=545429) in the Demo.txt file. By the way, I corrected the dates myself using Microsoft Access and then importing into PowerPivot from Access instead of the text file.
However, regarding this problem, I found that I could just type the formula =year(demo.[Date]), instead of using 'fx' and it worked OK. I don't have an answer to the cause of the problem as I have not tried it using other data.

 

[pinak.nubs]

Hello Derek,

thnx once again for such quick response....

both ur replies helped me solve the problem...