Expression that yield variant data type cannot be sued to define calculated Columns.

[tejapowerbi123]

Hello Everyone,

I am getting below error,

Error Descriptions:Expression that yield variant data type cannot be sued to define calculated Columns.

Data type:

Start Year=Whole Number

Start Month= Whole Number

Current Year= Whole Number

Current Month= Whole Number

Valid Price1 = IF((' Contracts'[Start Year]+[ Start Month]/12)<=([AUP Current Year]+[AUP Current Month]/12),[Monthly Discounted Price],"Contract Not Yet Started")

Does any has any suggestion?

Thanks

[Zubair_Muhammad · Accepted solution]

Hi

What if you use

Valid Price1 = IF((' Contracts'[Start Year]+[ Start Month]/12)<=([AUP Current Year]+[AUP Current Month]/12),[Monthly Discounted Price]&"" ,"Contract Not Yet Started")

[tejapowerbi123]

Thank you so much Zubair.