Compare similar data between two sheets

[Gkourtoglou]

Hello all,

I have an excel file with two sheets, 2019 & 2020.

Each sheet has the same columns (Staff Member, Department, Weeks, Ticket Replies).

Staff Member = Staff Name A, Staff Name B, etc

Department = Department A, Department B, etc

Weeks = Week 01, Week 02, etc

Ticket Replies = Number A, Number B, etc

I want to create a graph calculating the average of ticket replies per staff member 2019 vs 2020.

Thanks for your assistance.

[v-shex-msft]

HI @Gkourtoglou,

Maybe you can consider creating a new calculated table with UNION and SELECTCOLUMNS functions, then you can simply write a measure formula to extract current date value to calculate the difference between date different years.

If you are confused about coding formula, can you please share some dummy data with same data structure?

Regards,

Xiaoxin Sheng

[amitchandak]

Append two data

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Create a measure like average(table,table[ticket replies])

View by year

[jthomson · Accepted solution]

Stick a column in saying 2019 or 2020 respectively, append them together then just make a simple average measure, using the new column as a legend?