Forum Discussion

Lorrec's avatar
Lorrec
New Member
3 years ago
Solved

Power BI Column Query with Multiple Conditions

I have a Power BI dashboard that I built several years ago. I have a column in the dashboard that looks at the sixth letter in the server name. Based on it. The columns determine the environment. For example, for a server with the name serverx123, the environment would be Env1. 

 

I got a recent request to update the dashboard to show Room1 for servers with specific names. For example, serverx123 should now display in the dashboard as Room1 for their environment, not Env1. However, any server not explicitly listed should follow the switch flow. For example, serverx123 would be Room1, but serverx245 would be Env1.

 

I have tried multiple edits to my column DAX query but keep hitting roadblocks. Can someone point me in the right direction? Thank you for the help.

 

My Column

Column = SWITCH(REPLACE(LEFT(TRIM('Append'[Server Name]), 6), 1, 5, ""), "X", "Env1", "L", "Env2","No Env")

  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi  Lorrec ,

     

    I think you could nest another if statement, like this:

    Column =
IF (
    'Append'[Server Name] = "serverx123",
    "Room1",
    SWITCH (
        REPLACE ( LEFT ( TRIM ( 'Append'[Server Name] ), 6 ), 1, 5, "" ),
        "X", "Env1",
        "L", "Env2",
        "No Env"
    )
)

     

    Best Regards,
    Gallen Luo
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Community Support
    3 years ago

    Hi  Lorrec ,

     

    I think you could nest another if statement, like this:

    Column =
IF (
    'Append'[Server Name] = "serverx123",
    "Room1",
    SWITCH (
        REPLACE ( LEFT ( TRIM ( 'Append'[Server Name] ), 6 ), 1, 5, "" ),
        "X", "Env1",
        "L", "Env2",
        "No Env"
    )
)

     

    Best Regards,
    Gallen Luo
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Lorrec's avatar
      Lorrec
      New Member
      3 years ago

      Thank you for the help. I tried something similar but could not get it to work. Your example was what I needed.