Forum Discussion

VPonnarath's avatar
VPonnarath
Frequent Visitor
7 years ago
Solved

Sorting week is not working

Hello,   I have created a calculated column for the "Week Name-Month" in my date table which display the Month and the week number of the particular month.    Week Name-Month = CONCATENATE('Date'...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    VPonnarath,

    Please update your formula to the following, then change data type of week sort column to whole number.

    Week Sort Column = CONCATENATE('Date'[Calendar Month Number],'Date'[Week Number of Month])



    This way, when you sort Week Name-Month column by Week Sort Column, you will get expected sort.



    Regards,
    Lydia

     

parry2k's avatar
parry2k
Super User
7 years ago

i think your sort column should be

 

MM-Week Number of Month, like 

 

01-01

01-02

01-03

...

12-01

12-02

12-03

 

And use this new field to sort your "Week Name-Month" field

 

VPonnarath's avatar
VPonnarath
Frequent Visitor
7 years ago

BRILLIANT !! 

 

That worked like a charm.  Thank you so much  !! :)