Forum Discussion

CapnShanty's avatar
CapnShanty
Frequent Visitor
7 years ago
Solved

Summarize throwing "multiple columns cannot be converted to a scalar value"?

LATEST = SUMMARIZE('Main StatusHistory','Main StatusHistory'[AccountID],'Main StatusHistory'[CurrentStatusID],"LastDate",MAX('Main StatusHistory'[EntryDate]))     I am following along with the sol...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi CapnShanty,


    SUMMARIZE function will return a table, please create a new table to receive result or do summary on result to return single value to use in column or measure.

     

    Reference link:

    SUMMARIZE Function (DAX)

    Returns a summary table for the requested totals over a set of groups.

     

    Regards,

    Xiaoxin Sheng