Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago
Solved

Creating a Column using a Nested Find

Hello all: I'm trying to create a column where the value will be based off and email domain. The below is what I have, but it keeps throwing an error.   Country = IF (FIND("@Domain1.com", IF (FIN...
Need Help
  • Barthel's avatar
    Barthel
    3 years ago

    So, if the domain is equal to one of the four then it is Canada otherwise US? Maybe this will work for you: 

    Column =
IF (
    CONTAINSSTRING ( 'Table'[Email Address], "@Domain1.com" )
        || CONTAINSSTRING ( 'Table'[Email Address], "@Domain2.com" )
        || CONTAINSSTRING ( 'Table'[Email Address], "@Domain3.com" )
        || CONTAINSSTRING ( 'Table'[Email Address], "@Domain4.com" ),
    "Cananda",
    "US"
)
PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago

Thanks!  That got it.  What is the purpose of the double pipes at the beginning of the lines?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

That's the OR operator.