Forum Discussion
Solved
hi, really sorry if this very basic..summarize function
Hi, I am trying to use the summarize function but got stuck with the 3rd argument - it is not accepting the 3rd argument 1.trying to create a table using the summarize Customers_GropBy_Table=SUM...
Raj007 You need four arguments in your case. You have to name the field for the expression so like this:
Customers_GropBy_Table=SUMMARIZE(
'Sales SalesOrderDetail','Sales SalesOrderDetail'[CustomerID],"Sales Amount",[Sales Amount])
Raj007 You need four arguments in your case. You have to name the field for the expression so like this:
Customers_GropBy_Table=SUMMARIZE(
'Sales SalesOrderDetail',
'Sales SalesOrderDetail'[CustomerID],"Sales Amount",[Sales Amount])
Hi Greg & Push, you both are correct, - thank you so much guys ...
SUMMARIZE(table, [groupbyconame], [name1],[expre1] )
