Skip to content
The Chat Archive
claude-3-5-sonnet-20241022· Anthropic LMArena Human Preference 140K

Let's say I have an Excel file and in column C I would like to include multiple keywords…

  1. User

    Let's say I have an Excel file and in column C I would like to include multiple keywords (that are to be searchable) within Power BI. E.g. I want to have them separated by a comma: gloves,fingers,hand. Is that possible?

  2. Assistant

    Yes, it's absolutely possible to have multiple keywords in a single cell in Excel (separated by commas) and use them in Power BI. There are several ways to work with such data in Power BI:

    1. Keep as is:
    • You can keep the comma-separated values in a single cell
    • Use functions like FIND() or CONTAINS() to search within the text
    1. Split into separate rows:
    • In Power Query, you can split the column by delimiter (comma)
    • Use "Split Column" → "By Delimiter" → "Advanced Options" → "Split to rows"
    • This will create separate rows for each keyword
    1. Split into separate columns:
    • Split the column into separate columns if you know the maximum number of keywords
    • Use "Split Column" → "By Delimiter" → split to columns

    Example search in DAX:

    FilteredTable = 
    FILTER(Table,
        SEARCH("gloves", Table[Column], 1, 0) > 0
    )
    

    The best approach depends on how you plan to use these keywords in your analysis.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.