Logical DAX problem

[Anonymous]

Good morning!!!!

I have recently encountered a problem when developing a formula in which I compare several dates to check the delivery status of a milestone.

I need to unify three conditions to validate a state and the problem before me is that I can only use two arguments when I use the AND function.

I have to validate three dates at once, but I can't find a way to do it.

The structure I have achieved is as follows, I would need to compare a third date (Committed Date Review-Blank())

IF(AND(Milestones[Committed Date]<DATE(2020,11,30),Milestones[Actual Date Compliance]-Blank()),"3. Milestones Not Fulfilled"

If anyone can help me, it would be quite a dream!!!!

Thanks a lot!

[AlB · Accepted solution]

@alvarolpz17

Example:

IF (
    Milestones[Committed Date] < DATE ( 2020, 11, 30 )
        && Milestones[Actual Date Compliance] = BLANK ()
        && Milestones[Committed Date] > DATE ( 2020, 08, 31 ),
    "3. Milestones Not Fulfilled"
)

where I've added a 3rd random condition so you can see the operator's usage &&

Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.

Contact me privately for assistance with any large-scale BI needs, tutoring, etc.

Bless you

[Anonymous]

Hello

But should I use IF in front of those AND conditions?

I get the following error...

[AlB]

Hi @Anonymous 

You can either use nested AND( )s or, easier, use the && operator, which is a logical AND as well:

condition1 && condition2  && condition3 &&  ....  && conditionN

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers