Forum Discussion
SUMMARIZE 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
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
Here is a picture of sample data including a column I intend to reference(Highlighted). The Table is set to directquery.
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.
