Forum Discussion
Combining mutilpe dates into one field
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 |
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], "," )Best regards
Xiaoxin Sheng
3 Replies
av9 , why 10/10 is first column in case of James
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 |
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], "," )Best regards
Xiaoxin Sheng
