Forum Discussion
Solved
Addcolumn, different cases, summarize
Hello, I need help as I am trying to build a table with a case I never face untill now. I currently have a table with different line that I want to summarize. For example: date task ce...
hi Foguete
try to create a calculated table like:
Table =
VAR _table=
ADDCOLUMNS(
SUMMARIZE(
TableName,
TableName[Date],
TableName[task]
),
"center", "c",
"Qty", CALCULATE(SUM(TableName[Qty]))
)
RETURN
UNION(TableName, _table)
verified and worked like this:
hi Foguete
if you mind the column ordering, try this:
Table = VAR _table= ADDCOLUMNS( SUMMARIZE( TableName, TableName[Date], TableName[task] ), "center", "c", "Qty", CALCULATE(SUM(TableName[Qty])) ) VAR _table2= UNION(TableName, _table) RETURN SELECTCOLUMNS( _table2, "date", TableName[date], "center", TableName[center], "task", TableName[task], "qty", TableName[qty] )Thank you FreemanZ , however I have been simplifying "TableName" and in reality it has more column. So on, UNION is throwing the error "it must have the same number of columns".
How can I get through that ?
