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.

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

Hi fabd ,

Do you want to create a new table? If so, you could try like this:

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

 

  • 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