Forum Discussion
Values comparision number to text
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 AIB,
problem is that VALID PRICE is a calculated column and i am not able to see in QUERY EDITOR.
Hang on, I'm getting confused here. If it's a calculated column, how have you been able to create one with numbers and text? What type is that column?
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
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?
thank you so much AIB and Alexis i will share PBIX as soon as i can.Thanks