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" )

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Share a dataset and show the expected result.