Forum Discussion

MauriceK's avatar
MauriceK
Frequent Visitor
4 years ago

Dax formule with AND / OR

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.

Need Help

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.