More than 1 IF statements for ID's

[dommyw277]

Hi, Im trying to add a column with several if statements. 

I have subscription ids eg abc1, def1, fgh1 and I want to say if abc1 then call it Azure Sub 1, if def1 then Azure Sub 2 etc?

How can i do this please? 

[dommyw277]

Thank you so much 🙂

[lbendlin]

How is this related to Power BI? What is IDS?

[dommyw277]

i meant id's - im trying to create a new column that says if id = such then resolve it as azure1 etc, make sense?

[lbendlin · Accepted solution]

New Column = SWITCH([Subscription ID],"abc1","Azure Sub1","def1","Azure Sub2","fgh1",Azure Sub3","Other")