Forum Discussion

juliliscarmo's avatar
juliliscarmo
Helper 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 ...
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.

     

v-yuta-msft's avatar
v-yuta-msft
Community 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.

 

juliliscarmo's avatar
juliliscarmo
Helper I
7 years ago

Thank you very much!