Forum Discussion

fabd's avatar
fabd
Icon for Helper I rankHelper I
6 years ago
Solved

How to group by ?

Hi, sorry for this basic question. I hang around the community before posting. I found some help, but i was not able to implement these advice in my case.   So, i have a following table :   ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hello @fabd ,

    I'm sorry for my mistake. Please try the formula below.

    Table 2 = 
SELECTCOLUMNS (
    'Table',
    "Model", 'Table'[Model],
    "DateMonth", 'Table'[datemonth],
    "CPU", 'Table'[CPU],
    "Frequency", 'Table'[Frequency],
    "RAM", 'Table'[RAM],
    "DistinctCount", CALCULATE (
        DISTINCTCOUNT ( 'Table'[Model] ),
        ALLEXCEPT ( 'Table', 'Table'[datemonth] )
    )
)

    3.PNG

    I changed the sample data. For more information, see the attachment.

fabd's avatar
fabd
Icon for Helper I rankHelper I
6 years ago

Hello Xue,

 

How do you make a group by to count number of Model for each year/month ?

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hello @fabd ,

I'm sorry for my mistake. Please try the formula below.

Table 2 = 
SELECTCOLUMNS (
    'Table',
    "Model", 'Table'[Model],
    "DateMonth", 'Table'[datemonth],
    "CPU", 'Table'[CPU],
    "Frequency", 'Table'[Frequency],
    "RAM", 'Table'[RAM],
    "DistinctCount", CALCULATE (
        DISTINCTCOUNT ( 'Table'[Model] ),
        ALLEXCEPT ( 'Table', 'Table'[datemonth] )
    )
)

3.PNG

I changed the sample data. For more information, see the attachment.

  • fabd's avatar
    fabd
    Icon for Helper I rankHelper I
    6 years ago

    thanks xue, i am going to try

    • fabd's avatar
      fabd
      Icon for Helper I rankHelper I
      6 years ago

      Hi again,

       

      Thanks for the quick tutorial for working with a new table.

       

      I successed to do what i want. Thanks all of you for your help !

       

       

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi fabd ,

        Glad you have resolved it.🙂 Can you please share your formula and accept it as a solution? More people who have the same requirement will benefit here.