Forum Discussion
query data in several columns
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
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