topic Re: Date Sortfo in Desktop

Date Sortfo

tebtim19 — Fri, 12 Mar 2021 16:22:45 GMT

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

Doesn't look like sorted

Re: Date Sortfo

Anonymous — Fri, 12 Mar 2021 16:53:30 GMT

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.

Re: Date Sortfo

tebtim19 — Fri, 12 Mar 2021 16:58:34 GMT

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

Re: Date Sortfo

Anonymous — Fri, 12 Mar 2021 17:01:42 GMT

Hello tebtim19

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

Re: Date Sortfo

tebtim19 — Fri, 12 Mar 2021 17:12:30 GMT

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] )

)

Re: Date Sortfo

Anonymous — Fri, 12 Mar 2021 17:20:48 GMT

Hello tebtim19 ,

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

Re: Date Sortfo

tebtim19 — Fri, 12 Mar 2021 17:28:19 GMT

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

Re: Date Sortfo

Anonymous — Fri, 12 Mar 2021 17:42:42 GMT

Hello tebtim19 ,

Try this

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

Re: Date Sortfo

tebtim19 — Fri, 12 Mar 2021 18:07:14 GMT

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.