Solved: MaxRow wirh multiple condition - Page 2

desmond_lee · 08-17-2023 08:29 PM

Hi Guys

I try to pack MaxRow timestamp by Standard Tool ID with a condition COl M = "PASS". I write this expression

[_THISROW]=MAXROW("Calibration Database","TIMESTAMP",
AND(
[_THISROW].[STANDARD TOOL ID]=[STANDARD TOOL ID],
[CALIBRATION CONCLUSION]="PASS")
)

But it does not work. This tool MT1509-27 RULER ST suppose to be filtered because Col M="FAIL". Where is the mistake ?

AleksiAlkio

How about..

AND([TIMESTAMP]=MAX(SELECT(Calibration Database[TIMESTAMP],
[_THISROW].[STANDARD TOOL ID]=[STANDARD TOOL ID])),
[CALIBRATION CONCLUSION]="PASS"
)