Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

error in "FIND" function

Hi,   I'm having issues with text funciton "find". I use it to partition string into columns (to create table with couple of additions later)      The expression is Pandl_key2 = ADDCOLUMNS( SUM...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Anonymous,

     

    Please try the expression below
    Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)

     

    Regards,

    Chalrie Liao

     

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

Please try the expression below
Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)

 

Regards,

Chalrie Liao

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Charlie, 

     

    thanks for your answer.. it worked well.

    I found that there were some blank values, which probably caused this troubles. Your solution can fix this.

     

    Best regards :-)

    Zuzana