Forum Discussion

Foguete's avatar
Foguete
Icon for Helper I rankHelper I
3 years ago
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...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

Foguete's avatar
Foguete
Icon for Helper I rankHelper I
3 years ago

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 ?

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Foguete 

i am afraid there might be no easy workaround. How many column do you have?