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 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 

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

1 Reply

  • 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