Forum Discussion
Date range in dynamic text box
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”?
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
Anonymous , seem like danextian has provided the solution. Please check and mark it as solution, if it worked for you