Thanks for the help, i was doing the same but somehow the calculated measure i was using had issues, over complicated things. Thanks it works now.
Also i want to get one more column - avg rank across years.
ex - if week 2 had rank 6 & 8 in year 2016 & 2017. then the avg rank column should have 7 (6+8/2) for week 2 across 2016 & 2017. Would be great if you could help with this.