Forum Discussion
Dynamic Text Box with Date Range
Hi, I would like to add a text box that dynamically shows the rolling 12 month date range in my Month & Year page filter which is set to Relative Date, is in the last 12 calendar months. For...
Anonymous , You can create a measure and use that in text box, make sure Q&A feature is enabled
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = eomonth(_max, -12) +1return
"Rolling 12 Month " & _mn & " to " _max
Managed to get this to work with date format in DD/MM/YYYY for UK format.
Rolling 12Mth Title =VAR _Max = FORMAT(MAXX(ALLSELECTED(Dates),Dates[Date]),"DD/MM/YYYY")VAR _Min = EOMONTH(_MAX,-12)+1RETURNFORMAT(_Min,"DD/MM/YYYY")&" to "&_Max
amitchandak this is perfect thank you!