Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dommyw277
Helper III
Helper III

More than 1 IF statements for ID's

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? 

1 ACCEPTED SOLUTION

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

View solution in original post

4 REPLIES 4
dommyw277
Helper III
Helper III

Thank you so much 🙂

lbendlin
Super User
Super User

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

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

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.