Forum Discussion

R_'s avatar
R_
Regular Visitor
8 years ago

Nested If condition

Hi All,   How to make nested if condition in Power BI.   I have to create condition as :   If (Amount is <=1000 and Year is MaxYear) ,               If(Amount is between <1000 and Year = MaxYe...
Need Help
Tips and Tricks
MFelix's avatar
MFelix
Super User
8 years ago

Hi R_,

 

The best way is to use a SWITCH function something like this:

 

Period =
SWITCH (
    TRUE (),
    SUM ( Table[Amount] ) <= 1000
        && Date[Year] = MAX ( Date[Year] ), "Period",
    SUM ( Table[Amount] ) < 1000
        && Date[Year]
            = MAX ( Date[Year] ) - 1, "Period1",
    SUM ( Table[Amount] ) < 1000
        && SUM ( Table[Amount] ) > 1000
        && Date[Year] = MAX ( Date[Year] ), "Period2",

   ...,
    "ALL PERIOD"
)

Regards,

MFelix

  • R_'s avatar
    R_
    Regular Visitor
    8 years ago

    Hi ,

     

    Period =
SWITCH (
    TRUE (),
    SUM ( Table[Amount] ) <= 1000
        && Date[Year] = MAX ( Date[Year] ), "Period",
    SUM ( Table[Amount] ) < 1000
        && Date[Year]
            = MAX ( Date[Year] ) - 1, "Period1",
    SUM ( Table[Amount] ) < 1000
        && SUM ( Table[Amount] ) > 1000
        && Date[Year] = MAX ( Date[Year] ), "Period2",

    Hi Plz chk my requirement once again..

     

    If (Amount is <=1000 and Year is MaxYear) ,

                  If(Amount is between <1000 and Year = MaxYear-1) then "Period1" ,

                   If(Amount is between <1000 & >2000 and Year = MaxYear-1) then "Period2"...

     

    If (Amount is <=1000 and Year is MaxYear)  ::: this is common for period1 & period2..

     

    Thanks,