Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replacing multiple text values

Hi,    I'm looking to create a column that will display new text values. Below is the formula I've been using so far, but looking for something that would work using CONTAINS not EQUAL as there are...
  • gingerbread's avatar
    3 years ago

    You can use the DAX function SWITCH along with the CONTAINS function to check if the text field contains certain values and return different text based on the result.

    Here is an example of how you can modify your formula to achieve this:

     

    Column = SWITCH(
    TRUE(),
    CONTAINS('External Traffic'[Source Medium], "google / organic"), "Organic",
    CONTAINS('External Traffic'[Source Medium], "Facebook / Paid"), "Paid",
    "Other"
    )

    This formula will check if the Source Medium field contains the string "google / organic" and return "Organic" if it does, then it will check if it contains the string "Facebook / Paid" and return "Paid" if it does, and finally it will return "Other" if none of the previous conditions are met.