Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouping Names

Hi,   Currently this is the table I have.   I would like the table to be in this format.      How do I group the names, so there is only one player and the count of the injuries for ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Try this formula, please. It doesn't help. Please provide a sample in TEXT mode that we can copy from and the expected result.

     

    Breakdown =
CONCATENATEX (
    SUMMARIZE (
        'table',
        [name],
        [Injury Group],
        "countOfInjury", COUNT ( [injury] )
    ),
    [countOfInjury] & " "
        & [Injury Group],
    ","
)

     

    Best Regards,

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

Hi Anonymous,

 

Could you please mark the proper answers as solutions?

 

Best Regards,