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. The first part of the formula (before the second IF(AND) is working fine.

 

ISO YEAR = IF(AND(WEEKNUM(DateDIM2[datum];21) < 5 ; WEEKNUM(DateDIM2[datum];2) > 50) ; DateDIM2[Jaar]+1 ; IF(AND(WEEKNUM(DateDIM2[datum]; 21) > 50 ; WEEKNUM(DateDIM2[datum]; 2) < 5 ); DateDIM2[Jaar] - 1 ; DateDIM2[Jaar]))

Thanks a lot for helping me out.

 

Greetings Ronald

Ps. fbrossard

 

 

 

 

 

 

 

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

     

2 Replies

  • Omega's avatar
    Omega
    Impactful 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