Forum Discussion
Multiple condition in if
hello , please i need some help here what i have if ( ca = 0 ) in date1 and ca <>0 in date2 then 'new' else if ( ca in date1 < ca in date2 ) then 'up') else if (ca in date 1 > ca in date then 'd...
Hello, Switch should be perfect.
I assume two measures,
CA1 for ca in date1 and CA2 for ca in date2.
Switch(
TRUE(),
[CA1]=0 && [CA2]<>0, 'new', --condition 1
[CA1]>[CA2], 'up', --condition 2
[CA1]<[CA2], 'down' --condition 3
[CA1]<>0 && [CA2]=0, 'unknown' --condition 4
BLANK()) --elseFor further information check this article.
I hope this helps. I want miss the SWITCH function anymore.
he doesn't accept the switch in it :/
Hello, try to use the columns names instead of CA1 and CA2.
Best regards.