cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
notem
Frequent Visitor

Time Intelligence function 4x times slower than Filter

Simple model:

notem_2-1623579840720.png

Query with FILTER:

notem_6-1623581805587.png

Server Timings:

notem_5-1623581594687.png

Query with Time Intelligence function:

notem_8-1623581958600.png

Server Timings:

notem_7-1623581926062.png

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

 

 

 

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak, dax query from Performance Analyzer:

notem_0-1623884570841.png

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.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors