cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gibc Frequent Visitor
Frequent Visitor

Nested IF statements with several variables - convert from excel to DAX

I'm currently trying to convert existing excel formulas I have into PowerQuery (which i've only just started using).
A lot of it is straightforward, but i've come unstuck with nested IF statements. 

 

My formula in excel is:

 

IF([@ED]=TRUE,"high financial stress",

IF(AND([@LWM1]>2,[@FC]>2,[@LWM2]>2,[@ED]=FALSE,[@R]=FALSE),"no financial stress",

IF(AND([@LWM1]=1,(OR([@FC]<3)),(OR([@LWM2]<3)),[@R]=TRUE),"high financial stress","financial stress")))

 

And i need to convert this to DAX for a custom column.

Any help would be hugely appreciated Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Nested IF statements with several variables - convert from excel to DAX

@gibc,

 

You modify your formula using DAX below:

 

Result =
IF (
    [@ED] = TRUE,
    "high financial stress",
    IF (
        ( [@LWM1] > 2 )
            && ( [@FC] > 2 )
            && ( [@LWM2] > 2 )
            && ( [@ED] = FALSE )
            && ( [@R] = FALSE ),
        "no financial stress",
        IF (
            ( [@LWM1] = 1 )
                && ( ( [@FC] < 3 )
                || ( [@LWM2] < 3 )
                || ( [@R] = TRUE ) ),
            "high financial stress",
            "financial stress"
        )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
Community Support Team
Community Support Team

Re: Nested IF statements with several variables - convert from excel to DAX

@gibc,

 

You modify your formula using DAX below:

 

Result =
IF (
    [@ED] = TRUE,
    "high financial stress",
    IF (
        ( [@LWM1] > 2 )
            && ( [@FC] > 2 )
            && ( [@LWM2] > 2 )
            && ( [@ED] = FALSE )
            && ( [@R] = FALSE ),
        "no financial stress",
        IF (
            ( [@LWM1] = 1 )
                && ( ( [@FC] < 3 )
                || ( [@LWM2] < 3 )
                || ( [@R] = TRUE ) ),
            "high financial stress",
            "financial stress"
        )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.