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 & ...
@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

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