cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaulTorres
Regular Visitor

Why does paralelperiod generates a WHERE IN for the different dates

Good morning!

 

Hi I was trying to see what SQL queries does my Power BI report generate for the DB, and in my case i was trying a paralelperiod function to see how it is generated in the DB. I´m using a Direct Query connection to my DB in Vertica. This is the example DAX query:

RaulTorres_0-1626941031994.png

When I evaluate the query in DAX Studio I get that the selection of DATES for the query is done one by one with an IN. The column D_DT is Date Time format and when I see the SQL query in DAX studio the result is this: 

RaulTorres_1-1626941213920.png

If you look the scrollbar you realize there is a huge amount of Dates written one by one.

 

So my doubt is , isn´t this very inefficient? Wouldn´t it be better just to use a BETWEEN or any other way more efficient rather than generate all the DATES that is going to use one by one?

 

Thanks for your time!

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

6 REPLIES 6
lbendlin
Super User III
Super User III
V-pazhen-msft
Community Support
Community Support

Thanks, that is what i was looking for!

I have just tried it and it works in the same way. I´m not searching for a practical solution though, I´m just trying to know why it works the way it does and not other way that for me would look more efficient. But thank you anyways for the response.

lbendlin
Super User III
Super User III

I would agree but the developers probably have a good reason for not using BETWEEN.  Do you know what the compatibility level is for BETWEEN ?

Not really ,I was just asking myself why this was the way parallelperiod worked existing the other ways. But I also agree with you, the developers may have a reason for it

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