Forum Discussion
Pivot table and Time intelligence in Direct Query mode
Hi Happy new year every one 🙂 I've a table I want to show in a matrix table The key points : I'm in direct query mode. I need to compare data count with the same period of the previous year...
- Hi Anonymous ,I think you would have to create it for yourself by making columns [year], [quarter],[month],[date] and then use them to create a hierarchy.You can learn about modeling and reporting limitations of direct query connections in this document:Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
