Merge two table base on date

[Yannick63]

Hello

I'm loking for help to join in Power Query 2 tables

First table "BNS" containing material 

Material   begining_date              end_date

A1            10/09/2019 12:04:32    10/09/2019 13:00:25

A2            10/09/2019 13:00:25    10/09/2019 14:05:35

B1             10/09/2019 12:30:25    10/09/2019 14:00:26

B2             10/09/2019 14:00:26    10/09/2019 14:35:23

Second table "CAB" containing final product 

Id               begining_date              end_date

12            10/09/2019 12:32:35    10/09/2019 12:36:25

13            10/09/2019 12:40:25    10/09/2019 12:45:35

I need to have a final table  

Material   begining_date              end_date                        Id

A1            10/09/2019 12:04:32    10/09/2019 13:00:25     12

A1            10/09/2019 12:04:32    10/09/2019 13:00:25     13

A2            10/09/2019 13:00:25    10/09/2019 14:05:35

B1             10/09/2019 12:30:25    10/09/2019 14:00:26    12

B1             10/09/2019 12:30:25    10/09/2019 14:00:26    13

B2             10/09/2019 14:00:26    10/09/2019 14:35:23

I hope it's clear.

My 2 tables contains a lot of information so the most efficient solution will be appreciated 🙂

thank's in advance for you help

[Mariusz · Accepted solution]

Hi @Yannick63 

Please see the attached file with the solution.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Yannick63]

So many thanks @Mariusz  it seems to work perfectly

[Anonymous]

hi @Mariusz ,

Thanks for sharing your PBIX file. finally output showing correctly, But is there any other way to solve this Problem.

regards,

Naveen

[Mariusz]

Hi @Anonymous 

What is the logic in this scenerio, will it always happen on the same day?

Best Regards,
Mariusz

Please feel free to connect with me.