Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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
Thank you it worked 😀
@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
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |