Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

summarize vs addcolumn

Hello, The following two queries give the same result. Which is the best to use and why? I feel like summarize is simpler for me to use. Thank you   ADDCOLUMNS ( GROUPBY ( 'TableX' ,'TableO'...
  • marcorusso's avatar
    marcorusso
    6 years ago

    In reality this would the the best one:

    SUMMARIZECOLUMNS (
    TableO[field1],
    tableY'[field3],
    "duration", [field5]
)

    And if you cannot use SUMMARIZECOLUMNS then:

    ADDCOLUMNS (
    SUMMARIZE (
        TableX,
        TableO[field1],
        tableY[field3]
    ),
    "duration", [field5]
)
marcorusso's avatar
marcorusso
Most Valuable Professional
6 years ago

In reality this would the the best one:

SUMMARIZECOLUMNS (
    TableO[field1],
    tableY'[field3],
    "duration", [field5]
)

And if you cannot use SUMMARIZECOLUMNS then:

ADDCOLUMNS (
    SUMMARIZE (
        TableX,
        TableO[field1],
        tableY[field3]
    ),
    "duration", [field5]
)