add a measure in pivot based on dates (not a number)

Insert PT
1) Ensure "add this data to the data model" is selected
2) in the pivot tables fields dialog, right click "range" at the top
3) in the measure dialog,
(a) name the new measure i.e., comment or...
(b) in the formula editor, enter:

=MAX(
scroll down to Range[NOTE] and double click it and close with ")"

4) In the pivot table fields dialog, select fx comment

Here is a DAX solution using concatenatex

See
attached

Thanks for the Rep