DAX measure having multiple AND condition

[vishu263]

Hello,

I am trying to create a DAX measure for the following logic.

=If ([OT] = "co" And ([BO Date] >= [PIS Date] And [EO Date] <= [PIE Date])) Then "Y" Else "N"

I have written the below DAX & it is working fine.

=IF(AND(MAX('SA'[OT])="co", SUM('SA'[BO Date])>=SUM('SA'[PIS Date])),"Y","N")

However, it is satisying only the first 'AND' condition.

I am getting an error while including the second AND condition (Highlighted above in bold). I have written the below DAX for that condition. Not sure if it is the correct way of writing a DAX.

=IF(AND(AND(MAX('SA'[OT])="co", SUM('SA'[BO Date])>=SUM('SA'[PIS Date]), SUM('SA'[EO Date])<=SUM('SA'[PIE Date]))),"Y","N")

Can somebody please tell how to correctly include the other AND condition in the above DAX.

Thanks in advance.

[vishu263 · Accepted solution]

Hello,

I have managed to get the solution by writing the below DAX.

=IF(AND(MAX('SA'[OT])="co", SUM('SA'[BO Date])>=SUM('SA'[PIS Date]) && SUM('SA'[EO Date])<=SUM('SA'[PIE Date])),"Y","N")

It works perfectly fine. However please feel free If somebody knows the better solution for this problem.

Thanks

[vishu263]

I appreciate your help @devanshi .

It seems to be a matter of closing parenthesis which is causing an issue, otherwise rest everything looks fine.

Thanks anyways.

@tamerj1 can you please have a look and share your views.

[devanshi]

IF(MAX('SA'[OT]="co"),
        SELECTEDVALUE('SA'[BO Date]>=SELECTEDVALUE('SA'[PIS Date]) &&  SELECTEDVALUE('SA'[EO Date]<=SELECTEDVALUE('SA'[PIE Date]),"Y","N")
If above will give error then try this:
MeasureName = IF([OT] = "co" && [BO Date] >= [PIS Date] && [EO Date] <= [PIE Date], "Y", "N")

[vishu263]

Thank you @devanshi for proposing a solution. Unfortunately none of the above DAX is working in this case.

[devanshi]

Try this ,
IF(MAX('SA'[OT]="co") &&
        SELECTEDVALUE('SA'[BO Date]>=SELECTEDVALUE('SA'[PIS Date]) &&  SELECTEDVALUE('SA'[EO Date]<=SELECTEDVALUE('SA'[PIE Date]),"Y","N")