Different Dates Same Graph

[Morgan2000]

Hi,

I was wondering if anyone would be able to help, I have the below 2 graphs which show the last 12 months from the date selected or when the data goes to. E.g. Data is in up until June 2023 so will show June 2023 - July 2022. A rolling 12 months.

I also have another graph which is a 'comparison year' showing the same. For example, you select 2020 and it shows June 2020 - July 2019

Is there a way I can get this to show on one graph but keep it being 'July' at the start like the graphs are showing? I can't add a year filter as it causes the data to be split. Has anyone got any suggestions? 

[Syk]

You can create 2 measures for this and add them both on the graph. 
First measure would be..

PAX = sum(table[pax]) //or whatever your calculation is

Then, to get the previous year, we would reference the above measure.

PAX Previous Year = CALCULATE([PAX],dateadd(datetable[date],-1,year))

If you can go through the calculation of how you get your PAX line, we can get you an actual dax expression to calculate it.