topic Re: Power BI Column Query with Multiple Conditions in DAX Commands and Tips

Power BI Column Query with Multiple Conditions

Lorrec — Wed, 21 Dec 2022 12:59:56 GMT

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

Re: Power BI Column Query with Multiple Conditions

v-jialluo-msft — Thu, 22 Dec 2022 08:29:43 GMT

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.

Re: Power BI Column Query with Multiple Conditions

Lorrec — Thu, 22 Dec 2022 14:00:27 GMT

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