quarters in date table RRS feed

  • Question

  • Hello. How can I get "quarters" in a date table? Thanks. 
    Thursday, September 1, 2016 9:24 PM


  • Hi

    There are a few ways to add a [Quarter] column to the data table. 

    The first option is to add a calculated column to your date table that could look something like

    =ROUNDUP(MONTH([Date])/3, 0)

    The better option would be to add the column it to your source for the table. 

    if you are using SQL the new column would look something like

    DATEPART(QUARTER,  [date]) 

    you could use an external date table such as http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/

    Friday, September 2, 2016 4:06 AM