Display the Last year Shipments History in Measure for 53 weeks

Summary:

Hi All,

We need to show last year volume of Shipments History in measure. We create a measure similar to Shipments History 1 Year Ago. It is working fine at week level. We are using 5-4-4 weekly calendar and Fiscal calendar. At period level, the number are correct, but it is not working when we have 53 weeks in any of the year.

Currently we are using the measure expression:

Lag (Final Shipments History,364)

We need to handle the week 53. We are looking for the expression to apply the logic as below:

Summary of LY volume logic (Weekly)

Current Year