Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
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.
@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
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
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |