SUMMARIZE with column name does not work

[ryan1982]

While using SUMMERIZE DAX, I received an error message.

The dataset looks like below:

Can someone kindly let me know why? Thank you very much!

[amitchandak · Accepted solution]

SUMMARIZE returns a table, so you can create a new table. Or use that in your formula where a table is needed.

[amitchandak]

Table test = SUMMARIZE(Sales,Sales[Sales Date].[Year],"sales agg", sum(Sales[Sales Amount]))