Breaking Up Weeks When Quarter Ends




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?




  • ST_-Superman-_

    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.  

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
This discussion has been closed.