Forum Discussion
Grouping data with specific text in a column
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.
Not sure what the question is here. If you want to group items, you can create a new group based upon your column and group all things like "Sprains" together. Alternatively, you could create a custom column that does this based upon some formula where you use SEARCH or FIND perhaps. Again, not sure what you are going for here exactly.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
So the first chart uses the grouping, but when the data auto populates, it seperates out the new data and I have go back in and manually group them. I am trying to avoid this as the data is entered daily.
In an attempt to clarify, I am trying to duplicate the 1st picture but with the apprpriate DAX formula. Moreover, I am trying to ensure the numbers are accurate. The record number duplicates when multiple injuries are entered in to the database. Although there was a sprain to multiple parts of the body, I still want to count it as one event.
Record No Date Injury 244 5/23/2018 Rash 312 6/1/2018 Strain I hope this clarifies a bit.
I hope I havent stumped everyone!
Is there a DAX formula that would address my concern?
