Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    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.
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago
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.