Forum Discussion

jeyare's avatar
jeyare
Icon for Helper II rankHelper II
5 years ago
Solved

Offset + Match (Excel) equivalent in DAX

In a learning mode,  can't find a solution for this example (simplified). Thank you for your tip.   to column "Index W": - I need to MATCH the nearest greater value from "Weight B" for each evalua...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    Index W = 
MAXX(
    TOPN(
        1,
        FILTER( DATA, DATA[Age B] > EARLIER( DATA[Age B] ) ),
        DATA[Age A], ASC
    ),
    DATA[Weight A]
)

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago
Index W = 
MAXX(
    TOPN(
        1,
        FILTER( DATA, DATA[Age B] > EARLIER( DATA[Age B] ) ),
        DATA[Age A], ASC
    ),
    DATA[Weight A]
)