Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

ISO Year

Hi all,   I'am receiving a error message using the following DAX formula, 'Expressions that yield variant data-type cannot be used to define calculated columns.'. I can't figure out what is wrong. ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Omega,

     

     

    I found the solution. My Year column was formatted as text instead of a number value. This was the cause of the problem, because I was adding 1 to a text field. Thanks for replying. 

     

    Greetings

    Ronald

     

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
8 years ago

Can you please share the PBIX and what are you trying to calculate?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Omega,

 

 

I found the solution. My Year column was formatted as text instead of a number value. This was the cause of the problem, because I was adding 1 to a text field. Thanks for replying. 

 

Greetings

Ronald