I need urgent help to fix this Dax measure issue

[Anonymous]

Hi, 

I have measures like L1, L4, L13, L52 created in my report and these measures calculate total sales values based on the user-selected base week in the slicer. 

Example: If the user selects Base week format(Fiscal year and fiscal week) (202052) then,

1) L1 measure calculates total sales by subtracting 1 week and it will show total sales data for the week (202051)in the report and

2) L4 will calculate total sales by subtracting 4 weeks and it will show total sales data for the week (202051,202050,202049,202048) in the report

3) L13 will calculate total sales by subtracting 13 weeks and it will show total sales data for the week (202051,202050,202049,202048,202047,202046,202045,202044,202043,202042,202041,202040) in the report

4) L52 will calculate total sales by subtracting 52 weeks and it will show total sales data for the week (202051 to 202001) in the report

After the fiscal year got changed these formulae are not working properly. From Base week 202101 the formula is not working properly for L1, L4, L13, L52 Measure so I need to fix this issue.

List of measures used,

1)  L1 = CALCULATE([Total Sales],FILTER(Catman_Calendar,and(((Catman_Calendar[CY_BASEWEEK])=(MAX( Weeklist[Base Week]))),((Catman_Calendar[CY_BASEWEEK])=([CY_BaseWeek_Selected])))))

2) L4 = (CALCULATE([Total Sales],FILTER(Catman_Calendar,and(((Catman_Calendar[CY_BASEWEEK])>(MAX( Weeklist[Base Week])-4)),((Catman_Calendar[CY_BASEWEEK])<=([CY_BaseWeek_Selected]))))))

3) L13 = (CALCULATE([Total Sales],FILTER(Catman_Calendar,and(((Catman_Calendar[CY_BASEWEEK])>(MAX( Weeklist[Base Week])-13)),((Catman_Calendar[CY_BASEWEEK])<=([CY_BaseWeek_Selected]))))))

4) L52 = (CALCULATE([Total Sales],FILTER(Catman_Calendar,and(((Catman_Calendar[CY_BASEWEEK])>(MAX( Weeklist[Base Week])-52)),((Catman_Calendar[CY_BASEWEEK])<=([CY_BaseWeek_Selected]))))))

[amitchandak]

@Anonymous , check if my Week blogs can help

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8