Forum Discussion
Solved
Get Second highest value
I have following tables Build table with Code Coverage Mapping table - Work Item ID & Build ID And Work Item table Now, I have a measure that gives me the latest Build ...
Hi,
You can create a measure with the following logic:
Start data:
Dax:Second latest build =var latest = MAX('Matrix example'[Company]) returnCALCULATE(MAX('Matrix example'[Company]),'Matrix example'[Company]<>latest) //Exclude the latest from MAXEnd result:I hope this helps and if it does consider accepting this as a solutio nand giving the post a thumbs up!
