Forum Discussion
Compare similar data between two sheets
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.
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?
3 Replies
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?
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
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
