Hi,
Is there a way to break up a week when the quarter ends? For example- if the quarter ends on a Wednesday, is there a way for the next day (Thursday) to automatically start as week 1 of the next quarter on that next day?
Thanks!
You could use the rank and window function tile in an ETL dataflow to accomplish this. You would basically need to have several date fields present; year, quarter, month, week, and date.
Each field would essentially be a date calculation like YEAR(`Date_Field`), etc.
You could then make a windowed function to rank the weeks in a quarter.
