This content has been marked as final. Show 6 replies
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]