topic Re: Error using conditional logic in switch function in DAX Commands and Tips

Error using conditional logic in switch function

nbs33 — Wed, 13 Oct 2021 21:27:42 GMT

Hi,

I am trying to create buckets of customers based on % change YTD vs PYTD revenue. I only want to group negative values. I am getting strange results where all my negative values in my table are showing “< -30%”. Does anyone know what error I am making?

TEST Bucket = VAR testCondition = DIVIDE([YTD vs PYTD Revenue],[PYTD Revenue],0) RETURN SWITCH( TRUE(), testCondition<= 0 && testCondition> -30, "< -30%", testCondition<= -30 && testCondition> -40,"-30% to -39%", testCondition<= -40 && testCondition> -50,"-40% to -49%", testCondition<= -50 && testCondition> -60,"-50% to -59%", testCondition<= -60 && testCondition> -70,"-60% to -69%", testCondition<= -70 && testCondition> -80,"-70% to -79%", testCondition<= -80 && testCondition> -90,"-80% to -89%", testCondition<= -90 && testCondition> -100,"-90% to -100%" )

https://drive.google.com/file/d/1IjPb5BjE8eiqIqTHInvOYzuWh8QDtZ5S/view?usp=sharing

Re: Error using conditional logic in switch function

smpa01 — Wed, 13 Oct 2021 23:55:39 GMT

nbs33 can you try this

TEST Bucket = VAR testCondition = DIVIDE([YTD vs PYTD Revenue],[PYTD Revenue],0) RETURN SWITCH( TRUE(), testCondition> -100&&testCondition<= -90,"-90% to -100%", testCondition> -90&&testCondition<= -80,"-80% to -89%", testCondition> -70&&testCondition<= -60,"-70% to -79%" -------------------------------------------------------- -------------------------------------------------------- testCondition> -30&&testCondition<= 0,"0 to -30%")

Re: Error using conditional logic in switch function

smpa01 — Thu, 14 Oct 2021 19:46:23 GMT

nbs33 did you try this yet?

Re: Error using conditional logic in switch function

nbs33 — Thu, 14 Oct 2021 23:31:35 GMT

smpa01 this worked! The just had to change the values to decimal form and it worked perfectly.