Joining 2 tables as between in Sql query

Hi, I want to join 2 tables as attached. I want to join as inner join Product
on [Date]<=Period_end

Hi @dratan99,

Welcome to the forum. You can easily do almost all types of joins/merge within power query. Please have a look into below video to understand:


Hi, thanks for your reply. I saw that link, didn’t find useful for my requirement.

Hi @dratan99,

My bad as I missed your actual question. You need to get period information from product table to other table. I think you can check below article which explains exactly same scenario.

In case of any problem, please feel free to discuss or share your sample dataset if somehow this solution does not work for you. Cheers!

Thank you.

Hi @dratan99, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!