Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error Message - Expressions that yield variant data type cannot be used

Hello,

 

I am trying to create a calculated column using 2 text variables - Date and Product.  Date has been formatted first:

 

Date Formatted = FORMAT ('Table'[Date],"yyyymmdd")

 

then create calculated column

 

IR= IF('Table'[Product] = "BUSINESSACCESS" && 'Table'[Date Formatted] >= "20190705",0.75,
 
'table'[InterestRate]
)
Error message: Expressions that yield variant data-type cannot be used to define calculated columns.
Need Help

1 Reply

  • SabineOussi's avatar
    SabineOussi
    Skilled Sharer
    7 years ago

    Hello,

     

    Make sure 'table'[InterestRate] is of a numerical data type.