Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

String Searching - A replacement for CountIF

Hi all This is likely simple and i'm over doing it - But please help.   I have a dataset, there's 1 row per application.  There is a text string column for 'Region' which is annoyingly grouped wh...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To create a calculated column as below.

     

    Column = 
VAR se =
    SEARCH ( "Region 1", 'Table1'[Region String], 1, BLANK () )
RETURN
    IF ( ISBLANK ( se ), BLANK (), "Region1" )

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

To create a calculated column as below.

 

Column = 
VAR se =
    SEARCH ( "Region 1", 'Table1'[Region String], 1, BLANK () )
RETURN
    IF ( ISBLANK ( se ), BLANK (), "Region1" )

 

 

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.