Forum Discussion
Solved
Values comparision number to text
Hi, Can any one help for below error? In excel I have a valid price column and in that column has $amount and “Contract not started” comments, but when I try to replicate below formula in power...
The data type of column [Valid Price] cannot be whole number or decimal if you have any rows with "Contract Not Yet Started". It would have to be text. I guess you don't have any rows that have that value?
Hi,
Please see below forumula
Valid Price1 = IF((' Contracts'[Start Year]+[ Start Month]/12)<=([AUP Current Year]+[AUP Current Month]/12),[Monthly Discounted Price]&"" ,"Contract Not Yet Started")
***All columns data type is whole number,
is this not text?? The concatenation [Monthly Discounted Price] & "" should produce text
Maybe it'd be quicker if you shared your pbix