Forum Discussion

powerbihelp87's avatar
powerbihelp87
Icon for Helper V rankHelper V
5 years ago
Solved

If statement more than one table

I need help with multiple table If statement, I tried to give sample tables below.  If Column Code=100 then the new column should be XYZ else if the Column is Grp is 8fni then it should be ABC, the ...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey powerbihelp87 ,

     

    yes, you can write it like that:

    DAX Help Column =
SWITCH(
    TRUE(),
    'Table 1'[Code] = "100", "XYZ",
    RELATED( 'Table 2'[Grp] )
        IN {
        "8fni",
        "8vhi",
        "0kis"
    }, "ABC",
    "EFG"
)

     

    By the way, always link someone in an answer like that: powerbihelp87 

    Otherwise I won't get a notification that you answered.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

powerbihelp87 not really clear what you are looking for? How these tables are connected? What is your expected output give the logic you explained. The most critical part is how these tables are connected.

 

 

  • powerbihelp87's avatar
    powerbihelp87
    Icon for Helper V rankHelper V
    5 years ago

    selimovd  parry2k I was missing the Code column in the example Table 2 to show they are related, I was able to figure out the formula I needed below. It works fine.  I am trying to see how to write multiple options if the IF Related portion of the formula.

          

     DAX Help Column  =IF(Table 1[Code]="100", "XYZ",IF(RELATED(Table 2[Grp]="8fni","ABC","EFG" ))

    • selimovd's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hey powerbihelp87 ,

       

      sure, next time just give more details.

      You can make it more readable with a SWITCH/TRUE:

      DAX Help Column =
SWITCH(
    TRUE(),
    'Table 1'[Code] = "100", "XYZ",
    RELATED( 'Table 2'[Grp] ) = "8fni", "ABC",
    "EFG"
)

       

      If you need any help please let me know.
      If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
       
      Best regards
      Denis
       
      • powerbihelp87's avatar
        powerbihelp87
        Icon for Helper V rankHelper V
        5 years ago

        selimovd 

        Thanks Denis! 

         

        Do you know how I can write the syntax if there are multiple options for this portion:

         RELATED( 'Table 2'[Grp] ) = "8fni"

        For example if any of these from Grp field: "8fni" or "8vhi" or "0kis"  THEN it is ABC