Forum Discussion
Swtich Statement with multiple logic statements
Hello community! Hoping to get some professional DAX help before I need professional counseling.
Trying to set a value for a list of 15 conditions. I am starting out with a value of 100 and then evaluate each of the conditions. If they are met then the value is reduced by a variable amount. Using a swith statement like immediately below evaluates the first one and stops.
<condition1> && <condition2> && ... <condition 15>,<result1>,
<condition1> && <condition2> && ... <condition 15>,<result2>
...
<condition1> && <condition2> && ... <condition 15>,<result15>
)
ghutchins Perhaps a better way would be to simply have 15 separate IF statements that return the negative value or 0 in variables. Then you just add each variable to your starting Award amount.
1 Reply
ghutchins Perhaps a better way would be to simply have 15 separate IF statements that return the negative value or 0 in variables. Then you just add each variable to your starting Award amount.