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…
- 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?
- 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:
- 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
- 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
- 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.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.