cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## Concatenating results from an IF statement

Hi all,

I am trying to have a multiple IF Statement where it looks for a value and then if it matches it adds the result but if it only matches the third or fourth IF Statement then it adds those values instead.

Example:

=IF(Col1 || Col2 >0, "Ans1", IF(Col3 || Col4>0, "Ans2", IF(Col5 || Col6>0, "Ans3", "Ans4))))

Desired Outcome:

Row1 where Col1 = 1 and Col5=2 result would equal "Ans1Ans3"

Row2 where Col1=0 and Col6=6 result would equal "Ans3"

Row3 where all Col=0 result would equal "Ans4"

All thoughts and help would be gretaly appreciated!

1 ACCEPTED SOLUTION
Community Support

Hi @twolten,

Nope. dax not support calculation which you mentioned, you had to manually write formula/variable to calculate and return merged result .

Calculate column formula:

```formula =
VAR v1 =
IF ( Table[Col1] + Table[Col2] > 0, "Ans1" )
VAR v2 =
IF ( Table[Col3] + Table[Col4] > 0, "Ans2" )
VAR v3 =
IF ( Table[Col5] + Table[Col6] > 0, "Ans3" )
VAR v4 =
IF (
Table[Col1] + Table[Col2]  + Table[Col3] + Table[Col4] + Table[Col5] + Table[Col6] = 0,
"Ans4"
)
RETURN
IF ( v4 <> BLANK (), v4, v1 & v2 & v3 )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

Hi @twolten,

Nope. dax not support calculation which you mentioned, you had to manually write formula/variable to calculate and return merged result .

Calculate column formula:

```formula =
VAR v1 =
IF ( Table[Col1] + Table[Col2] > 0, "Ans1" )
VAR v2 =
IF ( Table[Col3] + Table[Col4] > 0, "Ans2" )
VAR v3 =
IF ( Table[Col5] + Table[Col6] > 0, "Ans3" )
VAR v4 =
IF (
Table[Col1] + Table[Col2]  + Table[Col3] + Table[Col4] + Table[Col5] + Table[Col6] = 0,
"Ans4"
)
RETURN
IF ( v4 <> BLANK (), v4, v1 & v2 & v3 )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Frequent Visitor

Thank you for this, it is really helpful!

However, I have run into another problem now. With the DAX calaculation complete I realised there is no way to parse the results of the calculation for filtering purposes.

For instance on result will have 'Ans1,Ans4' and another will have 'Ans1,Ans2,Ans3'

How can I parse these to be able to filter the results? Any ideas?

Thank you again for the help so far.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors