Calendar Sort Start of week in Filters Pane to most recent.

[bzafft123]

My calendar table was created in Power Query(= Table.AddColumn(#"Changed Type", "DateTable", each List.Dates(#date(2019,01,01), 365*6, #duration(1,0,0,0))).

I have a slicer that shows the most recent 'Start of Week' first (see below, from a different report, using a date field on a table instead of a calendar table). I want to see if I can get this same sort on the right in the filters pane on my current report. I have tried sorting the column by another column, but it's not working. 

Here is the filter pane view. 

Is it possible to have the most recent week show first?

[lbendlin]

Table.AddColumn(#"Changed Type", "DateTable", each List.Dates(#date(2019,01,01), 365*6, #duration(1,0,0,0))).

You are creating a six year calendar for each row of your table?!?

In DAX you can sort one column by another column.  Subtract each date from TODAY() and use that for sorting.

[bzafft123 · Accepted solution]

Thank you, yes, six years for forecasting purposes. I created a reference table that had a relationship to my date table. On that table, I kept columns Start of Week, Year, Name of Day, Week of Year, then filtered 'Name of Day' = 'Sunday.' Then created a column for the 'Current Week' with DAX below.

Current Week = VAR _Today = TODAY()

VAR _WeekToday = WEEKNUM ( _Today )

VAR _YEARToday = YEAR ( _Today )

RETURN IF ( UniqueStartofWeek[Year] = _YearToday && UniqueStartofWeek[Week of Year] <=_WeekToday  , "Y" )

Then I created another column on the reference table for the 'Start of Week' that was in Descending order:

Start of Week Descending = ((UniqueStartofWeek[Year] *100)  + UniqueStartofWeek[Week of Year] )*-1

Then I could add 'Start of Week' Column to the filter pane and add 'Current Week' = Y, which then filtered the filter to show the most recent week on top. 

The final result shows this:

I hope this helps someone else.