Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I was creating a switch statement for all the states in the US and Group them into per region. that will be used for a filter
I noticed that I have to declare each state in my switch statement. Just like below
State Groups = SWITCH( TRUE(),
sample[State] = "WV" , "CAPITAL",
sample[State] = "DE" , "CAPITAL",
sample[State] = "DC" , "CAPITAL",
sample[State] = "MD" , "CAPITAL",
sample[State] = "VA" , "CAPITAL",
and the rest goes on.
Is there a way to combine at least or write an OR statement instead of having 50+ lines?
Solved! Go to Solution.
@v_mark , I am adding in and Or example , both will work same in this case
State Groups = SWITCH( TRUE(),
sample[State] in{ "WV", "DE","DC","MD","VA"} "CAPITAL", // how to use in
sample[State] = "DE" || sample[State] = "DC" || sample[State] = "DE" , "CAPITAL", //how to use OR
"NA" //deafult va;ue
)
@v_mark , I am adding in and Or example , both will work same in this case
State Groups = SWITCH( TRUE(),
sample[State] in{ "WV", "DE","DC","MD","VA"} "CAPITAL", // how to use in
sample[State] = "DE" || sample[State] = "DC" || sample[State] = "DE" , "CAPITAL", //how to use OR
"NA" //deafult va;ue
)
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |