reendzz98Helper I4 years agoSolvedSwitch statement I want to create another column - Tier in my dashboard and below is the switch statement that I have queried: tier_testing = SWITCH( OFFICE[Sales] > 500, "Tier 1", OFFICE[Sales] >= 300 &&...Show Morereendzz984 years agotamerj1 Thank you for your respond. I have figured out the way to do it using multiple IF statement
reendzz984 years agotamerj1 Thank you for your respond. I have figured out the way to do it using multiple IF statement
reendzz984 years agotamerj1 Thank you for your respond. I have figured out the way to do it using multiple IF statement
tamerj1Community Champion4 years agoHi reendzz98 please change OFFICE[Sales] to SUM(OFFICE[Sales]). The rest I belive are measures so there should be no problem.
reendzz98Helper I to tamerj14 years agoHi tamerj1 thank you for your respond. I forgot to mention that [Sales] is actually a measure result from another measure. Does that affect my switch statement?tamerj1Community Champion to reendzz984 years agoWhat results are you getting?can you share a screenshot?reendzz98Helper I to tamerj14 years agothis is the name of the table and column that i actually used and as I add SUM, the red line appears Show More
reendzz98Helper I to tamerj14 years agoHi tamerj1 thank you for your respond. I forgot to mention that [Sales] is actually a measure result from another measure. Does that affect my switch statement?
tamerj1Community Champion to reendzz984 years agoWhat results are you getting?can you share a screenshot?
reendzz98Helper I to tamerj14 years agothis is the name of the table and column that i actually used and as I add SUM, the red line appears
Related contentSwitch statement in power queryNested switch statements?IF Statement or SwitchSwitch Statement Not WorkingReturn Filter from Switch Statement DAX
