Power BI Column Query with Multiple Conditions

[Lorrec]

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 · Accepted solution]

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]

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