Forum Discussion

Morgan2000's avatar
Morgan2000
Frequent Visitor
3 years ago

Different Dates Same Graph

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? 

 

 

Need Help

1 Reply

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    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.