Breaking Up Weeks When Quarter Ends

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!

Comments

  • 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.  

This discussion has been closed.