Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX measure having multiple AND condition

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.

 

 

@Dax
@dax @help
@Dax help
@Dax Measure Error
@Daxhelp
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

5 Replies

  • devanshi's avatar
    devanshi
    Icon for Helper V rankHelper V
    3 years ago

    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")

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

      • devanshi's avatar
        devanshi
        Icon for Helper V rankHelper V
        3 years ago

        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")

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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