Forum Discussion
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 ...
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.
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.
Hi MaryEliz21 ,
Create the appropriate date table and pass the sort by column
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.