Forum Discussion

tebtim19's avatar
tebtim19
Helper IV
5 years ago
Solved

Date Sortfo

Is anyone here know how to sort date for my slicer. Doesn't look like sorted  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello tebtim19 ,

     

    Sort Year Month column by Year Month# using sort by Column option

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello tebtim19 ,

 

You can Right click on column in data View and sort asc and Desc.

 

Let me know if this works for your date column.

 

  • tebtim19's avatar
    tebtim19
    Helper IV
    5 years ago

    Hi I tried that but it doesnt work. It's also weird that I can't see my date tabel in Query

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello tebtim19 

       

      Is it calculated column? if yes, you can't see in query editor

      • tebtim19's avatar
        tebtim19
        Helper IV
        5 years ago

        Its a calculated table 

         

        Dates =
        ADDCOLUMNS (
        CALENDAR ( DATE ( 2012, 1, 1 ), DATE ( 2021, 12, 31 ) ),
        "Year", YEAR ( [Date] ),
        "Month", FORMAT ( [Date], "MMMM" ),
        "Month #", MONTH ( [Date] ),
        "Year Month", YEAR ( [Date] ) & " " & FORMAT ( [Date], "MMMM" ),
        "Year Month #", YEAR ( [Date] ) * 100 + MONTH ( [Date] )
        )