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

 

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

3 Replies

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

     

  • lukiz84's avatar
    lukiz84
    Memorable Member
    1 year ago
    Result =
 IF(
   Table[Fab] IN {"N", "D"},
   "Done",
   IF(
      Table[Fab] = "Y" && Table[Trade] = "Fab",
      "Done",
      "Pending"
   )
 )