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.

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
6 years ago

Just Try Creating MAtix Table use rows and Columns to accomodate fields and let me know if any issue and paste the snapshot to see what else you require.

If this is an answer then you can mention this as an answer and share your Kudoes

Regards

Vijay Perepa

you can watch my Videos on www.youtube.com/perepavijay