Combining mutilpe dates into one field

[av9]

Hi, I have a table of customer meetings, and I want to summarise this so YTD dates appear in one cell. 
I.e. from this:

Customer	Meeting Subject	Date
John	Coffee catchup	10/08/2019
John	Teleconference	01/07/2020
John	Zoom catchup	10/10/2020
James	Coffee catchup	10/10/2020
James	Presentation	05/05/2020

To this:

Customer	Meetings YTD
John	01/07/2020, 10/10/2020
James	10/10/2020, 05/05/2020

[amitchandak]

@av9 , why 10/10 is first column in case of James

[av9]

The 10/10/2020 is the meeting date field.

So looks like this 

| Name | Meeting Subject | Date            |

| James | Coffee catch up  | 10/10/2020 |

| James | Presentation       | 05/05/2020 |

Then Summarise so it looks like this:

| Name | Date |

| James | 05/05/2020, 10/10/2020 |

[v-shex-msft · Accepted solution]

HELLO @av9,

I'm not so sure how the table is added, but I think you can try using the CONCATENATEX function to control the summarized table to extract and concatenate these date field values.

Measure =
VAR summary = 'your summary table formula'
RETURN
    CONCATENATEX (
        DISTINCT ( SELECTCOLUMNS ( summary, "Date", [Date] ) ),
        [Date],
        ","
    )

Dax CONCATENATEX function

Best regards

Xiaoxin Sheng