cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
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

https://www.dropbox.com/s/bi1woiapsgx8p4v/v1.3.pbix?dl=0 

1 ACCEPTED SOLUTION

@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") 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
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))

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

 

@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") 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors