Forum Discussion

JS's avatar
JS
Helper II
9 years ago

Delimiting with Conditions

Hello.    Is there anyway I can delimit a column based on a condition with another column.    Example.    Team                 Summary     A         This is an example - 100    B         This...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi JS,

Create the following columns in your table.

FirstCol = IF(Table1[Team ]="A",LEFT(Table1[Summary],FIND("-",Table1[Summary])-1),Table1[Summary])
SecondCol = IF(Table1[Team ]="A",REPLACE(Table1[Summary],1,FIND("-",Table1[Summary]),""),Table1[Summary])


Regards,
Lydia Zhang

JS's avatar
JS
Helper II
9 years ago

Thanks Lydia. 

 

I have tried - but I receive the following error message. "The search Text provided to function 'FIND' could not be found in the given text." Any idea what is wrong? 

 

Many thanks! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi  JS,

    Everything works as expected when I use your sample data. Do you copy the "-" from your column to FIND function? Would you mind sharing me your PBIX file so that I can troubleshoot?

    Regards,
    Lydia