Forum Discussion
Helper ISUMMARIZE Error
Hi All,
Im having a bit of an issue with using the summarize function. My syntax matches every example I can find but i still keep recieving an error.
Here is my Code:
AggEom =
SUMMARIZE(EOMCommonItemPLFormat,
EOMCommonItemPLFormat[MonthCode_FK],
"Gross Volume",SUM(EOMCommonItemPLFormat[TotalGrossAmount]))Here is the Error I recieve:
Any help is appreciated!
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.
4 Replies
- Greg_Deckler
Community Champion
Does your underlying EOMCommonItemPLFormat table contain any data? Can you post sample data from that table? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
jeffgarlischHere is a picture of sample data including a column I intend to reference(Highlighted). The Table is set to directquery.
- Greg_Deckler
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.