Forum Discussion
Nested If and & condition
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.
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, ...)
6 Replies
Anonymous Make sure that all the columns in the condition are of Number type. This is not an issue of multiple conditions.
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 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)
