Nested If and & condition

[Anonymous]

Hi All,

I am trying write if statement wtih mulitple & conditions like the below screenshot as shown in the image.

Kidly help me to fix the same.

[v-diye-msft]

Hi @Anonymous 

As the error says, DAX comparison operations do not support comparing values of type number and values of type text. 

Please use VALUE or FORMAt function to convert the values.

Official documents for your reference:

https://docs.microsoft.com/en-us/dax/value-function-dax 

https://docs.microsoft.com/en-us/dax/format-function-dax 

[Anonymous]

Hi, Thanks for the reply. Where i should make use of the VALUE function? 

Column = IF(Sheet1[ISCLOSED]="false",1,0)

Regards,

Viresh

[JirkaZ]

@Anonymous Now you are referring to completely different formula than in you original post. Here you don't need to do any conversions (if the IsClosed is a text field and not True/False field)

[Anonymous]

Hi, Yes it is different calculation and i got it.

could you pls suggest, where i can use the VALUE fucntion in the orginal expression.

Thank you.

[JirkaZ · Accepted solution]

Just check the definition of the function - https://docs.microsoft.com/en-us/dax/value-function-dax

It converts a number that is stored as text to a number so that you can compare it with another number. 

So in your original formula it would be like: 
IF(VALUE([Future Close Date]) > 99, ...)

[JirkaZ]

@Anonymous Make sure that all the columns in the condition are of Number type. This is not an issue of multiple conditions.