Forum Discussion
Multiple condition in if
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.
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()) --else
For further information check this article.
I hope this helps. I want miss the SWITCH function anymore.
thank you it work but i have juste a little problem i want to regroup my data by criterion . so i want to have those criterion in line and CA1 and CA2 in column ; the problem that power consider it as a measure so it automatically put it in colunm what ken i do please
Hello,
try to create a calculated column with this formula.
he doesn't accept the switch in it :/
Do you have several rows per Code Client?
i didn't understand what do you mean by several rows but here what i want to do in first place
after that i want to drill down in detail and display the client that belong to each class of new / up / down / vide