How to solve to problem? Count

[Seantoh]

Hi all,

May i know,

* what should i do if i want to know how many in total for "Number 1", "Number 2" until "Number 9999" ?

  can i do it in query editor before apply?

* what should i do if i want to know how many "Number 1" appeared in Jan, Feb, Mar, until Dec?

  can i do it in query editor before apply?

Appreciate for help!

Thanks

Regards

sean

[v-jiascu-msft]

@Seantoh,

Hi Sean,

Did you fail to do it with DAX? These two question is simple to handle with DAX. How much memory do you have?

Q1. Drag the column "Num" to the fields of a table visual twice. Set the first one to "Don't summarize" and set the second to "Sum".

Q2.

1) Create an independent date table.

DateTable =
CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) )

2) Establish relationship between DateTable[Date] and YourTable[Date].

3) Drag the DateTable[Date] and YourTable[Num] to the fields of a table visual. 

4) Set date to hierarchy of Year-Month and set [num] to count.

5) Filter out "Number 1".

Best Regards!

Dale

[Vvelarde]

@Seantoh

Hi, you can do it with Group By (Transform Menu)

Regards

Victor

Lima - Peru

[Seantoh]

hi victor,

i tried. evaluate out of memory. sad.