Forum Discussion

MaryEliz21's avatar
MaryEliz21
Regular Visitor
2 years ago

Sorting a graph

I have a set of data that reads latest weeks end 1/21/24, latest 4 weeks ending 1/21/24, latest 13 weeks ending 1/21/24 for multiple brands. The date will change every week. How do I get my graph to sort these in the correct order? It wants to put all the latest 4 together, latest 13 together, etc.

 

Thank  you!!!!

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MaryEliz21 ,

     

    Not quite sure what your intentions are. But you can refer to the following schedule:

    DimDate = 
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MMMM" ),
    "MonthSort", MONTH ( [Date] ),
    "Day", DAY ( [Date] ),
    "DayName", FORMAT ( [Date], "DDDD" ),
    "WeekDay", WEEKDAY ( [Date],2 ),
    "WeekStart",[Date] - WEEKDAY ( [Date], 2 ) + 1,
    "WeekSort",WEEKNUM([Date],1)
)

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

     

    • MaryEliz21's avatar
      MaryEliz21
      Regular Visitor
      2 years ago

      See in the below screen shot the weeks at the bottom of the chart. I need to get the dates in order, while keeping the 4 weeks in front of the dates. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi MaryEliz21 ,

         

        Create the appropriate date table and pass the sort by column

         

        Hope it helps!

         

        Best regards,
        Community Support Team_ Scott Chang

         

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