Forum Discussion
tejapowerbi123
7 years agoHelper V
Expression that yield variant data type cannot be sued to define calculated Columns.
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
- 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")
2 Replies
- Zubair_MuhammadCommunity ChampionHi
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")- tejapowerbi123Helper V
Thank you so much Zubair.