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:

     

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!