Joining 2 tables as between in Sql query

dratan99 · October 2, 2020, 9:39pm

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

hafizsultan · October 2, 2020, 10:12pm

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:

Regards,
Hafiz

dratan99 · October 2, 2020, 11:12pm

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

hafizsultan · October 3, 2020, 6:19am

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!

dratan99 · October 3, 2020, 2:39pm

Thank you.

EnterpriseDNA · October 6, 2020, 1:48am

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!