Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Summarize or groupby

Hi, Is there a DAX formula that'll allow me to summarize or group each row of same column into one row separated by , ?  I've tried summarize, combinevalues and groupby using concatenate but it onl...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on the sample and expected result you provided, I did the following test and wonder if it meets your needs?

     

    Please try measure like：

     

    JIRA ref_M = CONCATENATEX(VALUES('Table'[JIRA ref]),'Table'[JIRA ref],", ",'Table'[JIRA ref])
    SSP Code_M = CONCATENATEX(VALUES('Table'[SSP Code]),'Table'[SSP Code],", ",'Table'[SSP Code])

     

    then create a table visual with those measures, you can get a result like:

     

     

    A sample PBIX. for your reference is attached.

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan


    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Based on the sample and expected result you provided, I did the following test and wonder if it meets your needs?

 

Please try measure like：

 

JIRA ref_M = CONCATENATEX(VALUES('Table'[JIRA ref]),'Table'[JIRA ref],", ",'Table'[JIRA ref])
SSP Code_M = CONCATENATEX(VALUES('Table'[SSP Code]),'Table'[SSP Code],", ",'Table'[SSP Code])

 

then create a table visual with those measures, you can get a result like:

 

 

A sample PBIX. for your reference is attached.

 

Hope it helps,


Community Support Team _ Caitlyn Yan


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.