Forum Discussion
JK-1
Helper II
Helper IIDate string list - ascending order
Very novice here. Be gentle 🙂 Thanks I have a number of dates that are already sorted in column being referenced but when concat in new string they aren't given in Ascending order. Certs stri...
Hi JK-1 ,
You should be able to use the ORDER BY optional parameter in the concatenatex function. This should work:CONCATENATEX(FILTER(Site, Site[Site No] = EARLIER(Site[Site No])), [Effective Date], ";", [Effective Date], ASC)
Notice the second "Effective Date" field. We're using it to tell the expression to sort by the effective date in ascending order.
JK-1Helper II
Helper IIThanks for this. It returns the dates as just TRUE, TRUE, FALSE
Etc.
rather than just the date format previously. Was hoping there might be a way to only display the trues but with their dates intact - and for the false ones to drop out.
sorry for the overly complicated ask
