Forum Discussion

Helper IV

5 years ago

Solved

Date Sortfo

Is anyone here know how to sort date for my slicer. Doesn't look like sorted

Anonymous
5 years ago
Hello tebtim19 ,

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

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

Not applicable

5 years ago

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

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] )
)
- Anonymous
  Not applicable
  5 years ago
  Hello tebtim19 ,
  
  Sort Year Month column by Year Month# using sort by Column option
  - tebtim19
    Helper IV
    5 years ago
    Hi Thank you this solve my problem.
    I have one more thing to ask.
    
    I am trying to get the total number of male current employees.
    Males = COUNTROWS(FILTER('SAP Table'[Gender] = "Male"))
    
    But everytime I filtered it with my year month slicer it doesn't seems to work.
    I need to this so I could also get the Average of Male. Hopw you can help