Forum Discussion

steambucky's avatar
steambucky
Helper III
7 years ago
Solved

vairable value for a calculated column based specific words found in text data

I have some of the ideas, but not all to create the calculated column I need.   I want to write a calculated column where the value varies depending what specific words it finds in the text.   Th...
Need Help
  • affan's avatar
    affan
    7 years ago

    steambucky

     

    You can use the following to create a calculated column

     

    CalcCats = var _black=IF (
ISBLANK ( SEARCH ( "Black", Table1[Data], 1, BLANK () ) ),
0,1)
var _big=IF (
ISBLANK ( SEARCH ( "big", Table1[Data], 1, BLANK () ) ),
0,1)
var _cats=IF (
ISBLANK ( SEARCH ( "cats", Table1[Data], 1, BLANK () ) ),
0,1)
return _black+_big+_cats

     

    Attached is the file

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan