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