Forum Discussion

maclura's avatar
maclura
Icon for Resolver I rankResolver I
5 years ago
Solved

Date Table - DAX - CALENDAR() - ADDCOLUMNS() - Quarter Issue

Hi, I create a new Date table with DAX using the CALENDAR() function. Adding new columns, no problem. When I add a new "Quarter" colum into the table my table stops starting from Jan 1st and move...
ADDCOLUMNS()
CALENDAR()
Date Table
DAX
Quarter Issue
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, maclura , no worries, those other before July are not gone with the wind; but the mechnism under the hood is not clear.

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, maclura , no worries, those other before July are not gone with the wind; but the mechnism under the hood is not clear.

maclura's avatar
maclura
Icon for Resolver I rankResolver I
5 years ago

Thank you CNENFRNL . 
If I was a little more savvy, I would have to get there on my own. But I agree with you, why generated dates are sorted in that way?

  • maclura's avatar
    maclura
    Icon for Resolver I rankResolver I
    5 years ago

    After some other tests, I think it should be something related to a chaching mechanism.
    In fact, sorting issues happen not only with rows, but also with columns, when you add more columns into the formula. The new columns are created regardless of their position in the formula.
    If you create a new date table, when you run the formula the first time, columns are created in the order they appear into the formula.