Forum Discussion

Seantoh's avatar
Seantoh
Frequent Visitor
8 years ago

How to solve to problem? Count

        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...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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