Forum Discussion

kap_55's avatar
kap_55
Frequent Visitor
6 years ago
Solved

Sort Months by dates in date table

Hi,

 

I have my date table sorted by date and in visual my month are not sorted by by the date but by months alphabetically.
I have marked my table as date table too.

 

My date table:

 

My two visuals.

I disabled the hidden local date tables and created a hierarchy for above visual.

Does the hierarchy need to be sorted somehow?

 

Thanks for help.

K.

 

EDIT:

 

 

 

Calendar = 
ADDCOLUMNS (
     CALENDAR(DATE(1981;01;01);DATE(2080;12;31));
    "CALENDAR YEAR"; YEAR ( [DATE] );
    "MONTH NAME"; FORMAT ( [DATE]; "MMMM" );
    "MONTH NUMBER"; MONTH ( [DATE] );
    "WEEKDAY"; FORMAT ( [DATE]; "DDDD" );
    "WEEKDAY NUMBER"; WEEKDAY( [DATE];2 );
    "WEEK NUMBER";WEEKNUM( [DATE];21);
    "DAY"; DAY([DATE]);
    "QUARTER"; "Q" & TRUNC ( ( MONTH ( [DATE] ) - 1 ) / 3 ) + 1
)

 

 

EDIT2: File

 

https://drive.google.com/file/d/1AlsVzHyg0qV6WDkfE3-zf26xBT6oTA9z/view?usp=sharing

 

6 Replies