Translate an excel formula with Nested IFs and ABS

[SCrowley]

The excel formula compares the previous row to the next row. I have substituted the Column Letters with Names for ease:

=IF(LaneCount2=1,"Sole",IF(OR(LaneCount2=2,LaneCount2=3),"Small",IFERROR(IF(AND(BaseQuartile2>BaseQuartile1,ABS(CumuPct2-(BaseQuartile1*25%))<ABS(CumuPct1-(BaseQuartile1*25%))),BaseQuartile1,BaseQuartile2),1)))

I have written a DAX measure but my logic is off and I'm not sure how to fix it: (*Note, I'd also like to format the Numbers returned with no decimals example pasted below DAX formula)

EFQ TEST =

VAR EQ2 = SWITCH([LANE COUNT],1,"Sole",2,"Small",3,"Small")

VAR BQX25 = [BASE QUARTILE]*0.25

VAR PREBQ = CALCULATE(

    [CUMULATIVE PCT],

    FILTER(

        ALLSELECTED('MOAR Q'[Lane ID]),

        ISONORAFTER('MOAR Q'[Lane ID], MAX('MOAR Q'[Lane ID]), DESC)

    )

)

VAR CPMINUS = PREBQ-BQX25

RETURN

IF(AND(EQ2 = blank(), PREBQ<BQX25),BQX25,EQ2)

Thank you for your help.