week over week calculation

Hello Power BI Community, I need to calculate week over week variance from a source table in SQL DB . Please help me out with the below situation there is a heirarchy which goes like this Region >...