Date range in dynamic text box

[Anonymous]

Hi, how can I capture the dates selected in a text box, for example if users select date range of “01/01/2020” to “31/01/2020” for text box to say “Date range: 01/01/2020 to 31/01/2020”?

[amitchandak]

@Anonymous , seem like @danextian  has provided the solution. Please check and mark it as solution, if it worked for you

[danextian · Accepted solution]

Hi @Anonymous 

Try this:

Date Range =
VAR __MIN =
    FORMAT ( MIN ( 'Table'[Date] ), "MM/DD/YYYY" )
VAR __MAX =
    FORMAT ( MAX ( 'Table'[Date] ), "MM/DD/YYYY" )
RETURN
    "Date Range: " & __MIN & " to " & __MAX