Forum Discussion
Solved
query data in several columns
Hi all, I have a column whose values are a list of elements (variable) comma separated. For example: Column: Labels row1: apple, pear row2: apple, pear, strawberry etc. I separate these...
What you are asking for is doable, but it would be simpler if you do the following:
1. Don't split your initial data into separate columns, and instead add a custom column using Text.Split([TextListColumn], ", ") to create a list of values
2. Click on the arrow at the top of the new column and choose "Expand to New Rows"
3. Either Filter that new column for "Strawberry", or load the data and use a DAX measure and/or slicers to get your desired counts/analysis.
Pat
It works! Thanks mahoneypat