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 wi...
Need Help
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.