How to make the expression return 2021 instead of 2003 ?

[admin11]

Hi All

I have below expression from @amitchandak , it return 2003 , how to make it display 2021 ?

TITLE YTD DATE =

var _max = today()

var _min = minx(allselected('Date'), 'Date'[Date])

return format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES PERIOD"

Paul Yeo

[negi007 · Accepted solution]

@admin11 

see if below works for you.

TITLE YTD DATE =
VAR _max =
TODAY ()
VAR _min =
MINX ( ALLSELECTED ( 'Date' ), 'Date'[Date] )
VAR _year =
FORMAT ( _max, "YYYY" )
RETURN
FORMAT ( _min, "MMM" ) & _year & " to "
& FORMAT ( _max, "MMM" ) & _year & " SALES PERIOD"

[admin11]

@negi007 

Thank you very much 

it work fine now