ISO Year

[Anonymous]

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

 

[Omega]

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

[Anonymous · Accepted solution]

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