I want to display recent 2 years(current & prior) on a bar or line with month as dimension

[VishalSingh18]

Hello

My Date Dimension is CreatedDate and I want the graph to dynamically show values for the recent 2 years using 2 different lines/bar but event after lots of searching through community nothing seems to work

right now I am using Month(CreatedDate) along with year(CreatedDate) but it will just keep adding more lines as year count increases

Please help me with it

Thanks

[Kushal_Chawda · Accepted solution]

Create Month & Year field in your data model using calendar.

Then create line chart

Add 2 Dimensions:

1) Month

2) aggr(only({<Year={">=$(=max(Year)-1)"}>}Year),Year)

Measure:

Sum(Sales)  or whichever measure you want to select

[VishalSingh18]

Thank you very much i really helped