IF, Multiple

[AllanBerces]

Hi good day can anyone help me on my calculated column, 

   - If the Job_ID is equal to Y in Fab column then search Fab in trade column if none Pending if there is Done 

   - If the Job_ID is equal to N in Fab column then result is Done

   - If the Job_ID is equal to D in Fab column then result is Done

Thank you

[Cookistador · Accepted solution]

Hi @AllanBerces 

According to your snapshot

The following dax code should return what you need

RESULT=
IF(
    'Test'[Fab] = "Y",
    IF(
        CALCULATE(
            COUNTROWS('Test'),
            ALLEXCEPT('Test', 'Test'[Job ID]),
            'Test'[Trade] = "Fab"
        ) > 0,
        "Done", 
        "Pending" 
    ),
    "Done"
)

[lukiz84 · Accepted solution]

Result =
 IF(
   Table[Fab] IN {"N", "D"},
   "Done",
   IF(
      Table[Fab] = "Y" && Table[Trade] = "Fab",
      "Done",
      "Pending"
   )
 )

[Cookistador · Accepted solution]

Hi @AllanBerces 

According to your snapshot

The following dax code should return what you need

RESULT=
IF(
    'Test'[Fab] = "Y",
    IF(
        CALCULATE(
            COUNTROWS('Test'),
            ALLEXCEPT('Test', 'Test'[Job ID]),
            'Test'[Trade] = "Fab"
        ) > 0,
        "Done", 
        "Pending" 
    ),
    "Done"
)

[AllanBerces]

HI @Cookistador @lukiz84 Thank you very much for the reply, all goods