Date Sortfo

[tebtim19]

Is anyone here know how to sort date for my slicer.

Doesn't look like sorted

[Anonymous]

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]

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

[Anonymous]

Hello @tebtim19 

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

[tebtim19]

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 · Accepted solution]

Hello @tebtim19 ,

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

[tebtim19]

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]

Hello @tebtim19 ,

Try this 

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

[tebtim19]

Hi Still doesn't work when I select 2021 Feb I only got 3 males, which is supposed to be 209. I think the only number counter is the count of male added, but what I need is the total number of male filtered by month year.