How to use concatenatex and max(date) together?

[MattRasmussen]

I have a table with multiple records per project that I want to combine using concatenatex and keep the last date of the relevant records.  Here's an example of the table

[ID]	[Record Date]	[Status Notes]
123		22-FEB-2022		SOW finalized.
123		17-MAR-2022		Hardware and software installed.
123		25-MAY-2022		Fit gap analysis complete.
747		13-APR-2022		User acceptance testing beginning this week.
747		14-JUN-2022		UAT completed.

I'm looking for this as the result in a new table or query:

[ID]	[Record Date]	[Status Notes]
123		25-MAY-2022		SOW finalized. Hardware and software installed. Fit gap analysis complete.
747		14-JUN-2022		User acceptance testing beginning this week. UAT completed.

Is this possible in Power BI with DAX?  I can't get it to work.

[johnt75 · Accepted solution]

You can create a new table like

Summary Table = SUMMARIZECOLUMNS( 'Table'[ID], 
    "Record Date", MAX('Table'[Record Date]),
    "Status Notes", CONCATENATEX( 'Table',  'Table'[Status Notes], " ", 'Table'[Record Date], ASC)
)