Forum Discussion

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

Freeze Previous Week numbers in Every Week

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 upco...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    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.