I need to create a calculated measure with several conditions. Theoretically need to implement as an expression:
if (condition) then
else if (condition) then
I could only implement the If and Else.
Give us more details.
As Sunny said use Nested Ifs.
if(value < 2, 'Number is less than 2',
If(value <= 3, 'Number is less or equal to 3', 'Number is more than 3')) as Result
The outcome would be this:
Practically you can you as many nested ifs as you wish. But according to the situation you can apply other methods to reach the result.
If statement can be used in the script and in the expression. In both cases the logic is the same.
If works like following:
IF(logical condition, if logical condition is TRUE then do something, if logical condition is FALSE then do something)
Please test and create few examples yourself and you could easily handle the issue. Or just attach the sample qvw file.