Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
AtifMahmood
New Member

Combining Columns

Hi All

I have a table with columns "ITMDESC". I am adding a new column by searching a word from the ITMDESC and adding new columns with the searched name. like I am searching "SWITCH" from ITMDESC, if it is there it will write SWITCH in the column else "N". 

now I have three new columns, SWITCH, DAMPER, and FLANGE. what I need is to combine all three columns into one new column, where "N" is not there and only words like "SWITCH" or DAMPER or FLANGE will come from the columns. 

AtifMahmood_0-1686557049935.png

 

hope you understand.

Thanks in advance. 

 

Atif 

 

 

1 ACCEPTED SOLUTION

@AtifMahmood ,

  Sorry for the inconvenience. Please use the below code . It will work for sure.

CombinedColumn = 
IF(
    CONTAINSSTRING('Table'[itemdesc], "Switch"),
    "Switch",
    IF(
        CONTAINSSTRING('Table'[itemdesc], "Damper"),
        "Damper",
        IF(
            CONTAINSSTRING('Table'[itemdesc], "Flange"),
            "Flange",
            "N"
        )
    )
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

View solution in original post

3 REPLIES 3
AjithPrasath
Resolver II
Resolver II

@AtifMahmood ,

   You can use the below code:

CombinedColumn = 
CONCATENATEX(
    'YourTable',
    IF('YourTable'[SWITCH] = "N", "", 'YourTable'[SWITCH]) & 
    IF('YourTable'[DAMPER] = "N", "", 'YourTable'[DAMPER]) & 
    IF('YourTable'[FLANGE] = "N", "", 'YourTable'[FLANGE]),
    ", "
)

It will combine three columns into single column.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

thanks for your reply but this code

CombinedColumn = CONCATENATEX( 'Table1 (2)', IF('Table1 (2)'[SWITCH] = "N", "", 'Table1 (2)'[SWITCH]) & IF('Table1 (2)'[DAMPER] = "N", "", 'Table1 (2)'[DAMPER]) & IF('Table1 (2)'[FLANGE] = "N", "", 'Table1 (2)'[FLANGE]), ", " )
 is giving data like that.
AtifMahmood_0-1686566932840.png

what I need is that the new column just does not display "N". it will just display "Switch" or "Damper" or "Flanage" or whatever item is there in the ROW from columns. 

 

Hope i make you understand 

 

Thanks

@AtifMahmood ,

  Sorry for the inconvenience. Please use the below code . It will work for sure.

CombinedColumn = 
IF(
    CONTAINSSTRING('Table'[itemdesc], "Switch"),
    "Switch",
    IF(
        CONTAINSSTRING('Table'[itemdesc], "Damper"),
        "Damper",
        IF(
            CONTAINSSTRING('Table'[itemdesc], "Flange"),
            "Flange",
            "N"
        )
    )
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors