Hi @LipChean_Soh , Thanks a lot for this solution! This seems to be a great way to resolve the problem. I have actually made substantial progress and have defined all the necessary logic to get correct week values. However, I am stuck at the final issue of circular reference in which I am trying to get the Previous value of "Week End Date" in my "Week Start Date" formula. I wanted to know if there is a way for me to let the system understand that it is not a circular reference since I am referencing to the previous value of the "Week End Date"?? I have created a list "Fake Weeks" with 52 members in it (1..2..3..4.....52) Week List Week Start Date Week End Date 1 User Input Some Calculation using Week Start Date 2 Previous(Week End Date) + 1 Some Calculation using Week Start Date 3 Previous(Week End Date) + 1 Some Calculation using Week Start Date 52 Previous(Week End Date) + 1 Some Calculation using Week Start Date Below is a Snapshot of my blueprint - Please look at the text in RED- Weekly Time Dimension Week Start Date IF ITEM(Week) = Week.'1' THEN ADMIN Key Controls.CY Week Start ELSE BLANK(I want to Select Previous value of Week End Date)--This gives me circular reference if I use Week End Date[Lookup: Previous Week Property] 6+ Start Date Week Start Date + 6 No. of days in a month DAYSINMONTH(YEAR(Week Start Date), MONTH(Week Start Date)) Month End Date DATE(YEAR(Week Start Date), MONTH(Week Start Date), 'No. of days in a month') Weekday WEEKDAY(Week Start Date, 7) Week End Date IF Weekday = 1 THEN IF MONTH(Week Start Date) = MONTH('6+ Start Date') THEN IF Month End Date - '6+ Start Date' >= 5 THEN '6+ Start Date' ELSE Month End Date ELSE Month End Date ELSE IF Weekday <> 1 AND 7 - Weekday < 4 THEN Week Start Date + 7 - Weekday + 7 ELSE Week Start Date + 7 - Weekday Regards, GS
... View more
