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('Ca...
  • 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 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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.