March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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?
Solved! Go to Solution.
New Column = SWITCH([Subscription ID],"abc1","Azure Sub1","def1","Azure Sub2","fgh1",Azure Sub3","Other")
Thank you so much 🙂
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")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
97 | |
85 | |
69 | |
61 |
User | Count |
---|---|
138 | |
116 | |
114 | |
99 | |
98 |