Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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”?
1 ACCEPTED SOLUTION
danextian
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

danextian
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.