Help modifying a display text box value based on filters for future milestones

[DigitalDNA]

I have a display text box value based on filters with a list of milestones that currently works using the code below however I would like to modify it slightly so that only future milestones are displayed (i.e. those milestones occuring after today). Additionally, I would like to add 2 additional columns "Name" and "Meeting" into the mix so that the final output appears as: "Upcoming Milestones: 10/22/2021 Meeting Name, 10/23/2021 Meeting Name", and so on.  Thank you.

Measure = "Upcoming Milestones: "

& CONCATENATEX (

VALUES(Milestones[Target (End)])

, Milestones[Target (End)]

,", "

)

[AlexisOlson · Accepted solution]

Like this?

Upcoming Milestones =
"Upcoming Milestones: "
    & CONCATENATEX (
        FILTER ( Milestones, Milestones[Target (End)] > TODAY () ),
        FORMAT ( Milestones[Target (End)], "mm/dd/yyyy" )
			& " " & Milestones[Meeting]
			& " " & Milestones[Name],
        ", "
    )

[DigitalDNA]

How can I return only 1 milestone date, meeting, and name using the same solution and code referenced above?  That is, out of many future milestones that will occur after today, I only want to show the very next milestone (1 as oppposed to many).  Thank you.

[AlexisOlson · Accepted solution]

Next Milestone =
VAR NextDate =
    MINX (
        FILTER ( Milestones, Milestones[Target (End)] > TODAY () ),
        Milestones[Target (End)]
    )
RETURN
    "Upcoming Milestones: "
        & CONCATENATEX (
            FILTER ( Milestones, Milestones[Target (End)] = NextDate ),
            FORMAT ( Milestones[Target (End)], "mm/dd/yyyy" )
				& " " & Milestones[Meeting]
				& " " & Milestones[Name],
            ", "
        )

[DigitalDNA]

Brilliant--works perfectly, thank you!

[AlexisOlson · Accepted solution]

Like this?

Upcoming Milestones =
"Upcoming Milestones: "
    & CONCATENATEX (
        FILTER ( Milestones, Milestones[Target (End)] > TODAY () ),
        FORMAT ( Milestones[Target (End)], "mm/dd/yyyy" )
			& " " & Milestones[Meeting]
			& " " & Milestones[Name],
        ", "
    )