Based on my test with your sample data, you should be able to use the formula(DAX) below to create new calculate column in Table1 in your scenario.
FIRSTNONBLANK ( Table2[Column4], 1 ),
Table2[Column1] = Table1[Column1]
&& ( Table1[Column2] >= Table2[Column2]
&& Table1[Column2] <= Table2[Column3] )
View solution in original post
This works perfectly.
Thank you to every one for your time it is very much apritiated
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!