Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need Help with IF Statement in a Measure

I have 3 tables (excel tabs) linked to produce my report ( Data, FY2018, FY2019). "Data" table contains "FiscalYear" column. The goal is to get the Gauge Visual to display values from FY2018 table i...
if statement
measure
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous Yes you can multiple nest if statement

     

    if ( your condition, True value, if( your condition, true value, if ( your condition, true value, false value ) ) )

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k Thank you so much for your reply! I had to modify the syntax of the formula to make it work to IF( __selectedFiscalYear = 2018, SUM( FY2018[Amount], SUM( FY2019[Amount] ). So yes, it solved my origianl problem. However, now I have to make it more complex: IF a, THEN x, ELSEIF b, THEN y, ELSE z

Is there an easy what to do that? Thank you!

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous Yes you can multiple nest if statement

 

if ( your condition, True value, if( your condition, true value, if ( your condition, true value, false value ) ) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you very much! It worked.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You could also use switch to evaluate your conditionas, is like having multiple ifs....

     

    SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])