Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |