Forum Discussion

notem's avatar
notem
Frequent Visitor
5 years ago

Time Intelligence function 4x times slower than Filter

Simple model:

Query with FILTER:

Server Timings:

Query with Time Intelligence function:

Server Timings:

Can anybody explain this behaviour and give the links to articles with explanation?

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    notem , One of the reasons which I can think of is that time intelligence will return all dates and create an in clause for that.

    The best way to check is to enable performance analyzer and then get the DAX query from there and check

    • notem's avatar
      notem
      Frequent Visitor
      5 years ago

      amitchandak, dax query from Performance Analyzer:

      Let see on images from DaxStudio in my first message. There above 300 pseudo-sql queries for Time Intelligence like following:

       

      ... ORDER_ITEM LEFT OUT JOIN DATES ... WHERE DATES[ISO_DATE] IN ...

       

      I think that situation occurs because of generality of the Time Intelligence functions. So Formula Engine can't  parse a query for good execution plan.
      But I never seen info that Time Intelligence might be slower than filter.