Forum Discussion

HDD009's avatar
HDD009
Frequent Visitor
6 years ago

DAX comparison operations is not detecting values

I am facing the issue, that my power bi doesn't seem to detect numbers as values, even if the data type of all columns is a number. So if I want to compare a column to an value with an comparison op...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi, HDD009 

If you could try these two formula to create a calculate column

 

If-Range = IF(Numbers[Number]<0,"Negative","Positive")

or

If-Range2 = IF(Numbers[Number]<0;"Negative";"Positive")

 

 

Best Regards,

Lin

HDD009's avatar
HDD009
Frequent Visitor
6 years ago

amitchandak yes it is a column

 

v-lili6-msft both are not working, seems like my settings are differeny whyever. It doesn't detect the value.

 

I have to add "VALUE(0)" 

If-Range = IF(Numbers[Number]<VALUE(0),"Negative","Positive")

 

How can I change that setting????