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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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 or follow my page on Facebook @DAXJutsuPBI.

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 or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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