Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Group by text

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 re...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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