Forum Discussion
Time-intelligence functions and aggregations based on group-by columns combined with relationships
Hi. I'm having some trouble with aggregate tables and time-intelligence functions. On MS Docs, see https://docs.microsoft.com/en-us/power-bi/desktop-aggregations, a situation as illustrated bellow ...
Did you ever get this solved?
I'm finding myself in a similar situation and wonder if there's a resolution in the logic or if there's a work-around that's been found!
RSVP
Hi. No, I never figured this one out.
The issue was "resolved" for us as we moved from using Power BI to using Azure Analysis Services as the data model layer. With AAS the model size limitations disappeared and we could drop the aggreation tables alltogether.
I raised a question regarding this at SQL PASS virtual summit in 2020 and it was said to be a known issue, but no solution other than avoiding aggregation tables was suggested.