6 Replies Latest reply: Sep 16, 2015 10:06 AM by Mark Graham RSS

    Recent 4 fiscal weeks excluding this week

    Mark Graham

      Hi all,

       

      I have a master calendar, where i load fiscal week and fiscal date.

       

      I want to load a new dimension where it contains the recent 4 fiscal weeks but not this week.

      Can someone pls help me on this.

       

      current fiscal week statement i'm using.

      if(week(SoldDate) > 5,week(SoldDate)-5, week(SoldDate) + 47) as [Fiscal Week]