cancel
Showing results for
Did you mean:
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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

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

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.

Community Support Team

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

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.