new mwasure error in power pivot

[prathamesh0112]

I'm working on a new measure for current year spending. I received the following error: 

This formula is invalid or incomplete: 'Calculation error in measure 'Spending'[CY Spending]: The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String.'.

Measure name: CY Spending

Formula:

=
VAR CY = MAX('Calendar'[Year])
RETURN
CALCULATE(SUM([Spending]),'Calendar'[Year]=CY)

please help me.

[Ritaf1983 · Accepted solution]

Hi @prathamesh0112 
According to the error message your column's "spending" data type is a string.
Modify it to a number and the formula should work.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly