SUMMARIZE with Group By year, month, day but it summed the year and the day

[danyeungw]

The following should group by "Trends[release_date].[Year], Trends[release_date].[Month], Trends[release_date].[Day]" and sum(rends[amt]) by year, month, and day. It ended up summing the year, day, and amt. What was it wrong? Thanks.

Table = SUMMARIZE(Trends, Trends[release_date].[Year], Trends[release_date].[Month], Trends[release_date].[Day], "Amount", SUM(Trends[amt]))

Month	Year	Day	Amount
January	40440	324	3,917.95
February	38418	257	6,205.80
March	46506	368	8,474.84
April	44484	347	6,129.23
May	42462	621	8,331.89
June	42462	325	690.20
July	40440	327	9,910.26
August	46506	360	8,552.71
September	42462	348	8,654.95
October	14154	48	4,857.30

[danyeungw]

Thanks @Shaurya. I just figured it out. I had to change the Year and Day to text instead of number. It doesn't really make sense to me that Year and Day were grouped by, but it worked. 

[amitchandak · Accepted solution]

@danyeungw , If the issue where they were getting summarized by default. You can change the property in column tools

Making it text is not the best solution, if that was done for same purpose

[Shaurya]

Hi @danyeungw,

I can't say for sure since I don't see your source data but here's the code that I tried and it gave the expected result:

Summary = SUMMARIZE('Table','Table'[Release Date].[Month],'Table'[Release Date].[Year],'Table'[Release Date].[Day],"Sum",SUM('Table'[Amount]))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts