I'm getting this error

[Anonymous]

Hi,

I try to implement the below calculation, but unfortunately, I'm getting the error. Do the needful please!

Year1 = CALCULATE(Irdbook[Bookings],FILTER('Calendar','Calendar'[Year]=(MAX('Calendar'[Year])-4)))

Error message :

Calculation error in measure, DAX comparison operations do not support comparing values of type text with values of type number. Consider using the VALUE or FORMAT function to convert one of the values.

[tamerj1 · Accepted solution]

Hi @Anonymous 

first step is to double check the data type of the Calendar[Year] column. 
Also, is Irdbook[Bookings] a column or a measure? If column, you need to provide some sort of aggregation like SUM, MIN, MAX or AVERAGE 

[Anonymous]

Hey Thanks, @tamerj1 Data type was mismatched in the calender [year]. Now it has been fixed.