Forum Discussion

JoanCampbell's avatar
JoanCampbell
Frequent Visitor
5 years ago
Solved

IF statement for 3 criteria

Value = IF(AND((Merchandising[Merchandizing Type]="Pack out to shelf" || Merchandising[Merchandizing Type]="Pack out to Exsisting Display"||Merchandising[Merchandizing Type]="Pack out to new display"...
Need Help
  • TomMartens's avatar
    TomMartens
    5 years ago

    Hey JoanCampbell ,

     

    if you are using the DAX and want to use AND then you have to write your DAX like so:

    ...
IF(
AND( AND( condition1 , condition2 ) , condition3 )
, TRUE branch
, FALSE branch
)
...

    using DAX this will work as well, keep in mind that || means OR and && means AND

    ...
IF(
( condition1 && condition2 && condition3 )
, TRUE branch
, FALSE branch
)
...

     

    Hopefully, this provides the missing link, and helps to tackle your challenge.

     

    Regards,

    Tom

     

TomMartens's avatar
TomMartens
Super User
5 years ago

Hey JoanCampbell ,

 

if you are using the DAX and want to use AND then you have to write your DAX like so:

...
IF(
AND( AND( condition1 , condition2 ) , condition3 )
, TRUE branch
, FALSE branch
)
...

using DAX this will work as well, keep in mind that || means OR and && means AND

...
IF(
( condition1 && condition2 && condition3 )
, TRUE branch
, FALSE branch
)
...

 

Hopefully, this provides the missing link, and helps to tackle your challenge.

 

Regards,

Tom

 

JoanCampbell's avatar
JoanCampbell
Frequent Visitor
5 years ago
Value = IF((Merchandising[Merchandizing Type]="Pack Out to Shelf"&&Merchandising[Merchandizing Type]="Pack Out to Existing Display"&&Merchandising[Merchandizing Type]="Pack Out to New Display"),(Merchandising[Qty]*Merchandising[Price])) 
 
comes back blank. 
  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    Hey JoanCampbell ,

     

    you have to use || instead of &&. Using && means AND, the condition asks for a row where the same column has to have 3 different values at the same time.

     

    Please excuse, in my 1st reply to your question I replaced the || by && as I was concentrating more on the combination of three conditions as of the content.

     

    Regards,

    Tom