Forum Discussion

juliliscarmo's avatar
juliliscarmo
Icon for Helper I rankHelper I
7 years ago
Solved

Calendar by Quarter.

Hello everyone,

 

I'm wondering if you can help me.

I have two dates, one at the beginning and the other at the end of the calendar, I'm wondering if I can create a calendar / table only with the quarters between those dates.

For example, if the minimum date is 3/31/2015 and the maximum date is 03/31/2016, the result of the new tab shoud be:
03/2015
06/2015
09/2015
12/2015
03/2016

 

Thank you,

Juli

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    juliliscarmo ,

     

    First click Modeling-> New Table and create a calendar table using DAX below:

    Table = CALENDAR(DATE(2015, 3, 31), DATE(2016, 3, 31))

    Then create a calculate column in the Table using DAX below and change the text format to date(MMMM yyyy):

    Filtered Date = IF(MOD(MONTH('Table'[Date]), 3) = 0, CONCATENATE(YEAR('Table'[Date]), CONCATENATE("/", MONTH('Table'[Date]))))

     

    Finally create another table using DAX below and use filter to remove the blank value:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    juliliscarmo ,

     

    First click Modeling-> New Table and create a calendar table using DAX below:

    Table = CALENDAR(DATE(2015, 3, 31), DATE(2016, 3, 31))

    Then create a calculate column in the Table using DAX below and change the text format to date(MMMM yyyy):

    Filtered Date = IF(MOD(MONTH('Table'[Date]), 3) = 0, CONCATENATE(YEAR('Table'[Date]), CONCATENATE("/", MONTH('Table'[Date]))))

     

    Finally create another table using DAX below and use filter to remove the blank value:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.