Return complete String from multiple columns searched by a susbstring

[sparvez]

Hello Altruists,

I am in a complex situation trying to solve for last few days, but see no hope. Can anyone pls help me?

In a table, i have many columns. Some rows have the info of "TV". I need to get the complete string of TV by using substring "TV" in the new added column columntoFindTV. How to do it pls ?

column1---column2---column3---column4---columntoFindxxTV
1xTV---1xRadio---2xLaptop---(null)---1xTV
(null)---3xIpad---2xTV---(null)---2xTV
1xbook---5xRadio---2xPhone---5xTV--5xTV

thank you in advance.

[sparvez]

problem solved in this URL https://community.powerbi.com/t5/Power-Query/Return-complete-String-from-multiple-columns-searched-b...

[sparvez]

Hi, I probably made a mistake,  its a power query question, I asked the question there. thanks for your time.

[v-easonf-msft]

Hi, @sparvez 

It seems that you have found the solution in the post below.

Return complete String from multiple columns searched by a susbstring 

If so, please accept your own reply as a Solution to close this thread. Thanks.

Best Regards,
Community Support Team _ Eason

[lukiz84]

columntoFindxxTV :=
IF (
    FIND ( "TV", 'Table'[column1],, -1 ) <> -1,
    'Table'[column1],
    IF (
        FIND ( "TV", 'Table'[column2],, -1 ) <> -1,
        'Table'[column2],
        IF (
            FIND ( "TV", 'Table'[column3],, -1 ) <> -1,
            'Table'[column3],
            IF ( FIND ( "TV", 'Table'[column4],, -1 ) <> -1, 'Table'[column4], "N/A" )
        )
    )
)