Dynamic Title to show Prior Month from Selected Value

[atowriss99]

I have  visual where I want the table to say 'Current Month vs Last Month' with the month names changing dynamically based on slicer value.

What I have currently is this:

Current v Prior Month = SELECTEDVALUE('Date'[Month Name Short])& " " &SELECTEDVALUE('Date'[Year])&" versus Prior Month"

So, if Feb 2023 is selected it says "Feb 2023 versus Prior Month".

What I want it to say is "Feb 2023 versus Mar 2023"

My search has only provided solutions that don't involve a slicer by using TODAY or NOW.

Can this be done?

Thanks

[Greg_Deckler · Accepted solution]

@atowriss99 Assuming you meant Feb 2023 vs. Jan 2023 and making various other assumptions about your data model then perhaps something like this:

Current v Prior Month = 
  VAR __CurDate = MAX('Date'[Date])
  VAR __CurMonth = SELECTEDVALUE('Date'[Month Name Short])
  VAR __CurYear = SELECTEDVALUE('Date'[Year])
  VAR __PrevDate = EOMONTH(__CurDate, -1)
  VAR __PrevMonth = FORMAT(__PrevDate, "mmm")
  VAR __PrevYear = YEAR(__PrevDate)
  VAR __Result = __CurMonth & " " & __CurYear & " versus " & __PrevMonth & " " & __PrevYear
RETURN
  __Result

[atowriss99]

Exactly what I wanted!

Thanks!