Forum Discussion

maybevlad's avatar
maybevlad
Helper I
9 years ago
Solved

Custom cluster

I have one colum with some values like

scot/english

english/scot

english

scot

so i want to filter my data by putting all this values in one cluster "english"

if it some easy way to do this?) i can make some more column and fill it with custom values like if ... then...

but mb its more easy way?

replace data not good variant, couse i want to update info every month.

 

 

Need Help

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi maybevlad,

     

    Have you tried using SEARCH function in this scenario? The formula below to create a new calculate column for cluster is for your reference.:smileyhappy:

    New Cluster =
IF (
    SEARCH ( "english", Table1[Column1], 1, 0 )
        + SEARCH ( "scot", Table1[Column1], 1, 0 )
        > 0,
    "English",
    "Others"
)

     

    Regards

    • maybevlad's avatar
      maybevlad
      Helper I
      9 years ago

      Not so good) Couse i want to filter all info via 20+ claster and want to use for this "filter" vvisualisation, as i understand its impossible to do this using "search"