Forum Discussion

aalfa's avatar
aalfa
Frequent Visitor
9 years ago
Solved

Create grouping based on a keyword

Hi there,   Can I create custom groups based on a keyword in a particular field?   For example, here are a few entries in my field:   - $10 cash drop - 6/19 interest expense - 6/20 interest e...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    maybe something like this could work?

     

    aalfa

     

    group=
    SWITCH (
        TRUE (),
        AND ( SEARCH ( "Disc", Fieldname ) = 1, SEARCH ( "Discovery", Fieldname ) = 0 ), "Disc",
        "NA"
    )

  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi aalfa,

     

    You could refer to below formula to create a calculated column:

     

    Grouping = IF(FIND("DISC",'Create grouping'[Column1],1,0)>0,"DISC","N/A")

     

    As FIND function is case sensitive, it will distinguish "DISC" and "Disc", the record containing "Discovery" will be excluded in result.

     

    Regards,
    Yuliana Gu 

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

Hi aalfa,

 

You could refer to below formula to create a calculated column:

 

Grouping = IF(FIND("DISC",'Create grouping'[Column1],1,0)>0,"DISC","N/A")

 

As FIND function is case sensitive, it will distinguish "DISC" and "Disc", the record containing "Discovery" will be excluded in result.

 

Regards,
Yuliana Gu