Forum Discussion

Foguete's avatar
Foguete
Helper 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
Helper 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
Super User
3 years ago

hi Foguete 

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

  • Foguete's avatar
    Foguete
    Helper I
    3 years ago

    Hi FreemanZ,

    Thanks for the DAX, a slight modification and I have found the solution.

     

    Here in red, it is in case someone would get there:

     

    UNION(
        SELECTCOLUMNS(
            TableName,
                "date", TableName[date],
                "task", TableName[task],
                "center", TableName[center],
                "qty", TableName[qty]
        ),
        _table)
    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      Brilliant! Great idea!