Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

I'm getting this error

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's avatar
    tamerj1
    4 years ago

    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 

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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