Datatype variant

[Jonas_Jonas]

Hello everybody!

I have two columns. A text column with different colors in it and a number column with values.

When i build the IF function there is the error message:

Can not use expressions that return the variant data type to define computed columns.

IF-Funtion:

= IF(table1[COLOR]="BLACK";table1[VALUE]*(-1);table1[COLOR])

I tried many different opportunities and i cant find the answer.

With kind regards

Jonas

[Jonas_Jonas · Accepted solution]

Hi everybody!

I solved the problem on my own.

Instead of writing *(-1) in the IF function, write a new measure with "-1".

The new IF function than is:

= IF(table1[COLOR]="BLACK";table1[VALUE]*([Measure];table1[COLOR])

With kind regards

Jonas