Had a slightly different requirement come in!

Need to get the previous business day of a date if that date is not a business day... again I would like to use...

Thanks for the help guys. Scott, your suggestion seems to work! Thanks 🙂

That didn't work I'm afraid. The data is still being restricted by IsBusinessDay, hence removing the non business days.

I've taken that where clause out and it still doesn't work 🙁

That didn't work I'm afraid. Same error 🙁

I've taken a slightly different approach.

I created a calculated column that reversed the sign for the total column if the type ='C'. I then created a measure for this new...

Anyone? 🙂

The previous company I worked for had their Fiscal Year starting on March 1st, holiday year starting on July 1st, and KPI year starting on November (the month the company...

Sorry VRT, let me explain a bit more..

The fact table has a dimension in it, which is deep and in one column. This column has 3 possible values. When I...

I will be doing it more than once. The calendar table will need to be updated once the public holidays have been added to the upcoming years. At the moment...

I actually managed to crack my piece of code too to get the same results as that CTE;

select datekey, CASE WHEN RIGHT(replace(datekey,'-',''),4) < 0406 then CAST(dateadd(year, -1,DateKey) AS nvarchar(4)) +...

That CTE seems to do the job! Thank you very much!

The calendar table has a datekey in the format of yyyy-mm-dd. There are then columns that display the date in different formats, years, months, quarters etc.

I asked the question about...

The Fiscal Year will always start on 6th April. I've managed to create the Fiscal Start Date based on the DateKey in the calendar table using this code;

SELECT DateKey, CASE...

Apologies for being vague!

The only issue I'm having with that datediff code is that I need the fiscal date to change every year. The calendar table will have 100 years...

I am using a calendar table. The code is intended for a stored procedure that will populate the calendar table.