Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
CapnShanty
Frequent Visitor

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 solution provided here:

 

https://community.powerbi.com/t5/Desktop/Latest-Value/td-p/101257

 

and encountering this error. I have a table with AccountID, EntryDate, and Current StatusID. AccountIDs occur multiple times at different entrydates, and I just want the latest one for each accountid, so I'm following that answer, but my summarize function is telling me "the expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." 

 

I don't know why, I seem to be following the necessary syntax?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.