Forum Discussion
Solved
Dynamic Title Measure
Here i need to Create one dax title measure
Now the year is 2023 IS SELECTED and month is Dec
So total we have 4 Quarter
I need to create one dax measure and it should be a dynamic
...
Hi AlanP514 ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
Measure = "Sales"&" "&"Q"&QUARTER(EOMONTH(MAX(Dim_Calendar[Date]),-3))&" "&"with"&" "&"sales"&" "&"Selected Month"&" "&MAX(Dim_Calendar[Month Name])&" "&MAX(Dim_Calendar[Year])(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi AlanP514 ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
Measure = "Sales"&" "&"Q"&QUARTER(EOMONTH(MAX(Dim_Calendar[Date]),-3))&" "&"with"&" "&"sales"&" "&"Selected Month"&" "&MAX(Dim_Calendar[Month Name])&" "&MAX(Dim_Calendar[Year])(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.