Year and Month in the same X-axis bar chart

[apires]

Hello,

Is it possible to have in the same X-Axis the average from last 4 years and the average from current year each month? Bellow a picture showing what I would like to create:

Thank you!

[MarcoWedel · Accepted solution]

one possible solution using a calculated dimension:

=Aggr(If(Year(MonthYear)<Year(Today()),Year(MonthYear),MonthYear),MonthYear)

for reference, using this data:

[apires]

Hi Marco

This answer is so close from what I need, If I may ask two more questions:

1) Is it possible for currently year show all month even I don't have the numbers yet? Something close to picture bellow 

2) I have uploaded two dummy values with 2023 date just for test, but it is showing as number not date. I don't know if makes any difference but my database is formated date like dd/mm/yyyy.