topic I'm getting this error in DAX Commands and Tips

I'm getting this error

Anonymous — Thu, 05 May 2022 12:45:20 GMT

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.

Re: I'm getting this error

tamerj1 — Thu, 05 May 2022 13:09:32 GMT

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

Re: I'm getting this error

Anonymous — Thu, 05 May 2022 13:13:19 GMT

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