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 

 

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] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello tebtim19 ,

     

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

    • tebtim19's avatar
      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 
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello tebtim19 ,

        Try this 

        males = CALCULATE(COUNTROWS(FILTER(SAP Table,SAP Table[Gender]="Male")),ALLSELECTED(Dates[Year Month]))