Forum Discussion
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 & ...
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