Group by text

[Anonymous]

Hi,

I have created a column to group different types of injuries.

The actual data set has more than 40 types of injuries.

Is there a more efficient way to do this? Rather than repeating this formula 40 times.

I have thought about manually creating the groups of the injuries in the fields tab but this would be quite time consuming.

Any thoughts?

Thanks in advance 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Apart from creating a calculated column with DAX, you can group different types of injuries with Conditional Column in Query Editor mode.

Alternatively, with Power Query, you can populate the search text into list and create custom function to iterator each one of them to check if within the text. Reference: How to search multiple strings in a string.

Best regards,

Yuliana Gu