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

 

Need Help

3 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    Seantoh

     

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

     

    Regards

     

    Victor

    Lima - Peru

    • Seantoh's avatar
      Seantoh
      Frequent Visitor
      8 years ago

      hi victor,

       

      i tried. evaluate out of memory. sad.

  • 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