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,

ofirk's avatar
ofirk
Resolver II
7 years ago

Hi,

Are you creating a calculated column?

Maybe this will work for you:

 

PointsPerMonth = SUMX(FILTER(Results, [Player] = EARLIER([Player]) && [Year] = EARLIER([Year]) && [Month] = EARLIER([Month])), [Points])