Get Max date from date Range slicer and concatenate with text

[blestone111]

hi Experts

i am trying to get the max date from a date range slicer and the once you have the max date from the date range slicer concatenate this into a new measure to show - out put as shown below.

[blestone111 · Accepted solution]

Worked it out

MAx Date = 
VAR MaxOrder = LASTDATE('Date Calendar'[Date])
RETURN
    "12 Months to"&" "& FORMAT(MaxOrder, "MMMM-YYYY")

[rajulshah]

Hello @blestone111 

You can try the below DAX formula and please let me know if this didn't work.

Max Date Text =
FORMAT ( MAX ( Dates[Date] ), "mmmm" ) & " - "
    & FORMAT ( MAX ( Dates[Date] ), "YYYY" )

Below is the result I got -

Thanks, let me know if you face any issues.