Forum Discussion
Solved
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 =
SUMMAR...
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.
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.
Ahhh see I figured as much, but none of the tutorials I watched mentioned that little bit of info! Thank you!
