Forum Discussion

bishnu's avatar
bishnu
Helper II
6 years ago
Solved

IF with multiple arguments and AND argument

Hello  I am trying to formulate a If statament with multiple arguments, but its always returning me 1. Following is the table and the colored green column is my intended result.    So its ch...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi bishnu , 

    You could add the condition in expresion like below to see whether it work or not

    Measure = IF(MIN('Table'[name]) IN {"REA","REB", "REC"} && MIN('Table'[date])<TODAY(), 1,0)
Column = IF('Table'[name] IN {"REA","REB", "REC"} && 'Table'[date]<TODAY(), 1,0)

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

dax's avatar
dax
Community Support
6 years ago

Hi bishnu , 

You also could try below codes

calculated column: Column = IF('Table'[name] IN {"REA","REB", "REC"}, 1,0)

Measure: Measure = IF(MIN('Table'[name]) IN {"REA","REB", "REC"}, 1,0) 

 You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bishnu's avatar
bishnu
Helper II
6 years ago

Hi dax

First check is for the status and It should also check the due date with current date and if due date has passed, then it will give me one 1, other wise 0.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi bishnu , 

    You could add the condition in expresion like below to see whether it work or not

    Measure = IF(MIN('Table'[name]) IN {"REA","REB", "REC"} && MIN('Table'[date])<TODAY(), 1,0)
Column = IF('Table'[name] IN {"REA","REB", "REC"} && 'Table'[date]<TODAY(), 1,0)

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.