cancel
Showing results for
Did you mean:

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

Anonymous
Not applicable

## Dynamic Test based on slicer selection -Selected value

Hi Experts

Based on the Month slicer Selection is would like my text to change accordingly. So if ythe user select from the month slicer Feb

AF / Apples Journey Time: Reported Feb 2019 - Jan 2020

if user selects Mar

AF / Apples Journey Time: Reported Mar 2019 - Feb 2020

so we have a rolling year view within the text...

1 ACCEPTED SOLUTION
Super User

Hi, you can create a measure that will return text. Let's see how can we build the following. Assuming you have a Calendar Table for that date filter:

``````Text Measure =
VAR __date = MIN(CalendarTable[Date])
VAR __first_date = EDATE(__date, -1)
VAR __second_date = EDATE(__date, -12)
RETURN
CONCATENATE(
"AF/Apples Journey Time: Reported ",
FORMAT(__first_date, "MMM YYYY")
& " - "
& FORMAT(__second_date, "MMM YYYY")
)``````

Hope that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

2 REPLIES 2
Super User

Hi, you can create a measure that will return text. Let's see how can we build the following. Assuming you have a Calendar Table for that date filter:

``````Text Measure =
VAR __date = MIN(CalendarTable[Date])
VAR __first_date = EDATE(__date, -1)
VAR __second_date = EDATE(__date, -12)
RETURN
CONCATENATE(
"AF/Apples Journey Time: Reported ",
FORMAT(__first_date, "MMM YYYY")
& " - "
& FORMAT(__second_date, "MMM YYYY")
)``````

Hope that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

Super User

@Anonymous , Assuming month is coming from date table or table having date. Try measure like

measure =
var _max = format(eomonth(maxx(allselected('Date'), 'Date'[Year]),-1),"MMM YYYY")
var _min = format(eomonth(maxx(allselected('Date'), 'Date'[Year]),-12),"MMM YYYY")
return
"AF / Apples Journey Time: Reported " & _min & " - " & _max

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors