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

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.