Create Titel measure with selected Month minus 3 month

[MaleneL]

HI 

I want to create a titel for my presentation, weher the titel is QX-202X but the last Quarter.  So if I have in my filter chosen Sep and 2023 I want the titel to be Q2-2023.

I have tryed 

selectedvalue(Dim_Calender[QuarterYear], -1, Quarter) 

this do not work...

[MaleneL]

Thank you it worked 😀

[swikritee_p · Accepted solution]

@MaleneL , Create a measure like 

Measure = 

var MaxDate_  = Maxx(allselecetd(Date), Date[date]) 

var ValueDt_ =  eomonth(MaxDate_  ,-3) 

return 

format(ValueDt_ , "\QQ YYYY") 

You can use this in title