Compare over two years data

[michellerob2000]

Im trying to create a line chart to compare no of tickets raised monthly over the two years. Ive tried to do it. I cant do it, really need some advice here.
Thanks

[v-kongfanf-msft · Accepted solution]

Hi @michellerob2000 ,

My question is, if you compare the number of work orders for two years on the same axis, how should the x-axis be determined? Is it possible to explain this so that I can answer it for you as soon as possible.

Tickets_CurrentYear = 
CALCULATE(
    SUM(Tickets[Tickets]),
    YEAR(Tickets[Date]) = YEAR(TODAY())
)

Tickets_LastYear = 
CALCULATE(
    SUM(Tickets[Tickets]),
    YEAR(Tickets[Date]) = YEAR(TODAY()) - 1
)

Best Regards,
Adamk Kong

[SamWiseOwl]

@michellerob2000  you need to add your ticket column into the Y axis.

I would put

Months in the X axis.

Years in the Legend.

TickedID or something else in the Y-axis to count.

[SamWiseOwl]

Hi @michellerob2000 

Since the data is the same, could you Append the two tables together in the Query Editor (Transform Data)

Then you could have a chart with sales in Y axus, the years in the legend and Months in the X axis 🙂

[michellerob2000]

Ive managed to append so thanks, but then i need to add the createddate from the 2023 table (should have 2024 data in tis too) but it doesnt work