Is it possible?

[ali_hijazi]

Hello I got the following requirement:
I should create line chart with Month as dimension
there should be 2 expressions
1. Sum(measure)
2. Sum(measure) but for each month I got find the value of the measure  the month that is one year back or 12 months back

as you can see here in 2023-11 the value is 3052
while in 2022-11 the value was 2675
but the 2675 value is displayed under 2023-11

knowing that the above photo is a drawing
is it possible to accomplish this requirement using set analysis?

[Antoine04]

Hello,

You should use Month() function as dimension.

And create 2 measures.

One for CY : Year=Year(Today())

and one for LY : Year=Year(Today())-1

Regards

Antoine

[ali_hijazi]

but the dimension is the year-month
so under the same value of the dimension I want to display 2 values of the measure (CY and PY)
your suggestion dummy