Freeze Previous Week numbers in Every Week

[Arul]

Hi All,

I have a data which is grouped by Monday of every week. My requirement is, I need to freeze the previous week (W1) data on particular Monday and then freeze the next week of data on the upcoming week Monday (W2) and so on... The data is calculated from the same column which will change every week but I need to lock the numbers on every Monday of the week.

Thanks,

Arul

[amitchandak]

@Arul , You need to create a column like this in Date table, You can exclude weekend if needed

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)

[Arul]

@amitchandak ,

Thanks for the reply.

I need to calculate it for every week but the above formula would work only two conditions I guess. I hope you got my requirement.