Forum Discussion
Summarize error The expression refers to multiple columns. Multiple columns cannot be converted.....
Hey guys, I'm trying to summarize the Average from a coulmn grouped by state , but keep getting this error "The expression refers to multiple columns. Multiple columns cannot be converted to a sc...
Greg_Deckler
Community Champion
Community ChampionAnonymous Try AVERAGEX ( SUMMARIZE ( ... ), ... )
Y = AVERAGEX('Customer List', SUMMARIZE('Customer List','Customer List'[State],"y",.....)
What do I put in for the Expression argument of the summarize formula ??
If I put average it pops with the same error
What do I put in for the Expression argument of the summarize formula ??
If I put average it pops with the same error
- Greg_Deckler
Anonymous Try:
Y = AVERAGEX('Customer List', SUMMARIZE('Customer List','Customer List'[State],"y",SUM('Customer List[Last 6 Months Purchase]),[y])