Forum Discussion
Grouping data with specific text in a column
- Anonymous8 years ago
Bnb99 If I am understanding correctly you are trying to split the 2nd column based on the delimeter bracket. If that is correct you can do that in power query
by selecting the table and then clicking edit query and then clicking on add column adn then extract, text before delimeter and you use "(" as that delimeter and you can get the body part the same way. Once you have the 2 columns you can create 2 charts and then use the high level chart to drill into the other. for example first chart will have Rash, Strains etc and the second chart would have the body part.
if you have some additional logic which needs to go in that could be your standard dax formula with switch or if.
If this is not the requested output plz give example of what the final output from original data you want.