Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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")
User | Count |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |