Setanalysis in calendar script

[#1]

I am trying to add these to my calendar script could any one help me on that

• Same business day of the prior year (so today being Monday 2/8/16 what happened on Monday 2/9/15)
• Same business week of the prior year (so this week being 2/8 - 2/12/16, last year same time period 2/9 - 2/13/15)
• Based on date chosen, what is last fiscal year to date (so for FY 16 would be 10/1/15 to today 2/8/16)
• Based on date chosen, what is last calendar year to date (so for this year would be 1/1/16 to today 2/8/16)

Thank you

[Gysbert_Wassenaar]

LastWorkDay(AddYears(ToDay(),-1) as BusinessDayPriorYear

WeekStart(LastWorkDay(AddYears(ToDay(),-1)) as BusinessWeekPriorYear

YearStart(ToDay(),-3) as StartOfFiscalYear

YearStart(ToDay()) as StartOfYear

[#3]

Thank you Can i get the expressions for those so that i can employ them directly in straight table

[#4]

Sorry To make all the things mess up

Calendar with flags making set analysis so very simple

in that Zip file you will find a .qvw

in the same script i need these to be built.

• Same business day of the prior year (so today being Monday 2/8/16 what happened on Monday 2/9/15)
• Same business week of the prior year (so this week being 2/8 - 2/12/16, last year same time period 2/9 - 2/13/15)
• Based on date chosen, what is last fiscal year to date (so for FY 16 would be 10/1/15 to today 2/8/16)
• Based on date chosen, what is last calendar year to date (so for this year would be 1/1/16 to today 2/8/16)