Dax formule with AND / OR

[MauriceK]

How to write the following formula: 

defining a formula when  a employee contract is between a slicer period. 

I use a date table with no realations to employee contract period begin / end.  Conform youtube tutorial:

Power BI From and To Date Filtering with One Slicer - YouTube

These are my datatables: see below.

 wrote a basic formule which is unfortunately incorrect:

Can somebody help me. 

Thanks in advance.

[v-yanjiang-msft]

Hi @MauriceK ,

According to your description, I create a sample.

It gets the correct result by you formula.

I'm not clear why the slicer period in each row are different.

I attach my sample below, please point out the difference with yours.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.