Replicating an Excel table with calculated cells

MFelix  Thanks for details and really sorry for my late reply!

I got confused when I looked closer at your solution! seems you have used a different source for all your actions.

I have reshared the main table that was the source of all data and it shouldn't be changed in anyway before calling in Power BI. Please see the Dropbox excel file again I shared.

https://www.dropbox.com/s/kpdnhlmxifz0332/recordheightsOriginal.xlsx?dl=0

My Weeks table is created in Power BI by "enter data" feature.

Moreover, did you used 3 different tables in your pbix file(1st Exel Workbook + two pther tables in the same workbook)?

And is it possible to call next tables(Contestant and Weeks tables) without writing the code in Advanced editor?

Also I was wondering what was the last line? I have a different variant in it (i.e. #"Removed Clumns1"? How I can change it and what is the impact on my overall data model?

Many thanks again...