Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Formula - group by

I'm working on a formula, for a calculated table, that will group the following columns:   Player, Year, Month (all part of a table called Results)   I then want to provide a sum of the total poi...
Need Help
  • ibarrau's avatar
    ibarrau
    7 years ago

    It is great you found another way. But check your formula out, you are not writting the NAME:

     

    PointsPerMonth = GROUPBY(Results,[Player],Results[Year],Results[Month], "NAME", SUM(Results[Points]))

     

    Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm trying to create a a Calculated Table here (not a measure or column).

 

I have tried using this formula instead, but receive the error "Function GROUPBY expects a column name as argument number 5."

 

PointsPerMonth = GROUPBY(Results,[Player],Results[Year],Results[Month],SUM(Results[Points]))

 

I have however tried a different approach to crating a calculated tabel, which was to create a measure as: SumPoints = SUMX(Results,[Points]) which has worked when adding this to a visualisation.

 

Thanks everyone for your help & suggestions.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

It seems that you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best  Regards,

Cherry