Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

IF, Multiple

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...
Need Help
  • Cookistador's avatar
    Cookistador
    1 year ago

    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's avatar
    lukiz84
    1 year ago
    Result =
 IF(
   Table[Fab] IN {"N", "D"},
   "Done",
   IF(
      Table[Fab] = "Y" && Table[Trade] = "Fab",
      "Done",
      "Pending"
   )
 )
Cookistador's avatar
Cookistador
Super User
1 year ago

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"
)