Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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.

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
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

    Thanks for your response - my last post wasn't clear - in trying to do something else I created a calculated column called SumPoints using the formula above and used that instead of my calcualted table I was previously trying (looking back, I can't remember why I was going down the calculated table route in the first place).