Forum Discussion
jeffgarlisch
Helper I
7 years agoSUMMARIZE 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...
- 7 years ago
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.
Greg_Deckler
Community Champion
7 years agoDoes 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
jeffgarlisch
Helper I
7 years agoHere is a picture of sample data including a column I intend to reference(Highlighted). The Table is set to directquery.
- Greg_Deckler7 years ago
Community Champion
Ahh, see, details matter. SUMMARIZE is not a Direct Query compatible function.
- jeffgarlisch7 years ago
Helper I
Ahhh see I figured as much, but none of the tutorials I watched mentioned that little bit of info! Thank you!