cancel
Showing results for
Did you mean:
Post Prodigy

## Date in title to change dynamically to show last 12 months from selected date

Hi Experts

Need a measure that give the last 12 months based on the selected date in Slicer.

Assume i select Mar 21 in the Slicer.

Then i want the measure to show Feb 20 - Mar 21 i want to use this in a title

If i Select Feb 21 from Slicer

Then i want the measure to show Jan 20 - Feb 21 and so on

Sample File

1 ACCEPTED SOLUTION
Super User IV

@Route217 , Sorry , Try like

New measure =
var _max = maxx(allselected('Date', 'Date'[date])
var _min = eomonth(_max,-12)

return

format(_min ,"mmm YY") & " to " & format(_max ,"mmm YY")

Proud to be a Super User!

4 REPLIES 4
Super User IV

@Route217 , Try like

New measure =
var _max = maxx(allselected('Date', 'Date'[date])
var _min = eomonth(_max,-12)
return
calculate(sum(Table[Value]), filter(all('Date'), 'Date'[date] >=Min && 'Date'[date] <=_max && Date[Date] <=max(Date[Date])))

or

One of the three

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

Proud to be a Super User!

Post Prodigy

Hi Amit.. How would that give me.... as a text string  if i Select Mar 12 on Slicer ("Feb 20 to Mar 21")

Super User IV

@Route217 , Sorry , Try like

New measure =
var _max = maxx(allselected('Date', 'Date'[date])
var _min = eomonth(_max,-12)

return

format(_min ,"mmm YY") & " to " & format(_max ,"mmm YY")

Proud to be a Super User!

Post Prodigy

Thanks you sir.....Did you manage to look at the Tooltip one please.

Announcements